/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

7 votes199 views2 answers
Postgres concat
SQL
24 votes170 views6 answers
Rename a column in sql server
SQL
0 vote162 views2 answers
Influxdb delete measurement based on date
SQL
-1 vote196 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
0 vote181 views1 answer
What is metadata in sql
SQL
-1 vote277 views5 answers
Left join sql
SQL
0 vote210 views1 answer
Mysql best varchar length size
SQL
11 votes177 views2 answers
Mysql set safe mode off
SQL
57 votes2.2K views5 answers
How to create a new user in postgresql
SQL
0 vote181 views1 answer
Sql column contains special character
SQL