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!