Tim Landscheidt <tim@xxxxxxxxxxxxxxxxxx> writes: > (anonymous) wrote: >> Is there a way to find which functions are being used by table. >> Ex :- If there are functions fnc_a, fnc_b, fnc_c and table A is used in >> fnc_a and fnc_c, How can we find that ? can you please help? > Basically, you can't. Functions are more or less black boxes > to PostgreSQL. You could possibly grep all the functions' source code for references to the particular table you care about, eg select ... from pg_proc where prosrc ~ 'mytable' but bear in mind that this could miss dynamically-constructed queries. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
