List stored functions that reference a table in PostgreSQL
metaprogramming, postgresql, sql
Solution
SELECT p.proname
FROM pg_catalog.pg_namespace n
JOIN pg_catalog.pg_proc p
ON p.pronamespace = n.oid
WHERE n.nspname = 'public';
Problem
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: 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?