List stored functions using a table in PostgreSQL
Posted
by Paolo B.
on Stack Overflow
See other posts from Stack Overflow
or by Paolo B.
Published on 2009-10-13T08:54:54Z
Indexed on
2010/04/14
23:33 UTC
Read the original article
Hit count: 598
Just a quick and simple question: in PostgreSQL, how do you list the names of all stored functions/stored procedures using a table using just a SELECT statement, if possible? If a simple SELECT is insufficient, I can make do with a stored function.
My question, I think, is somewhat similar to this other question, but this other question is for SQL Server 2005:
http://stackoverflow.com/questions/119679/list-of-stored-procedure-from-table
(optional) For that matter, how do you also list the triggers and constraints that use the same table in the same manner?
© Stack Overflow or respective owner