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?