/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

24 votes121 views4 answers
How to add column sql
SQL
0 vote135 views1 answer
Automated psql csv export script on windows
SQL
2 votes134 views1 answer
Apex execute batch job
SQL
2 votes126 views1 answer
Compare date in sql
SQL
0 vote123 views1 answer
Mysql create table like
SQL
2 votes143 views1 answer
Coalesce sql
SQL
6 votes135 views2 answers
Sql display max value
SQL
2 votes128 views1 answer
How to insert string variable into sqlite database
SQL
2 votes135 views2 answers
Mysql show table column comments sql
SQL
1 vote123 views1 answer
Mysql connect bash
SQL