/SQL/List all functions and procedures in postgres query

List all functions and procedures in postgres query

SELECT   quote_ident(n.nspname) as schema , quote_ident(p.proname) as function 
FROM   pg_catalog.pg_proc p
JOIN   pg_catalog.pg_namespace n ON n.oid = p.pronamespace 
WHERE  n.nspname like '<schema-name>'

Similar codes

1 vote137 views2 answers
Sql groub by count
SQL
3 votes139 views2 answers
Mysql HAVING
SQL
0 vote137 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote93 views1 answer
Delete all rows from table sqlite
SQL
0 vote143 views1 answer
Guid string to binary better
SQL
0 vote136 views1 answer
T sql cursor tr
SQL
0 vote139 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote179 views1 answer
AddEntityFrameworkSqlite
SQL
2 votes145 views1 answer
Mysql time ago difference
SQL
0 vote128 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL