Thread: Function to Table reference

(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.

Tim

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