Re: Function to Table reference

Tim Landscheidt <tim(at)tim-landscheidt(dot)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