Sławosz Sławiński home

How to list postgres procedures

I needed to list all stored procedures on my postgres database. As usual, stack overflow helped: http://stackoverflow.com/questions/1559008/list-stored-functions-using-a-table-in-postgresql:

SELECT  p.proname
FROM    pg_catalog.pg_namespace n
JOIN    pg_catalog.pg_proc p
ON      p.pronamespace = n.oid
WHERE   n.nspname = 'public';

PS. I am using pgweb to inspect my postgres database, its awesome!

blog comments powered by Disqus
Fork me on GitHub