Function to Table reference
Hi All -
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?
regards
(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
got it.. Thank you
On Fri, Apr 30, 2010 at 12:17 PM, Tim Landscheidt <tim@tim-landscheidt.de>wrote:
Show quoted text
(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 usedin
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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