Tim Landscheidt <tim@tim-landscheidt.de> 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
