/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 votes214 views6 answers
Rename a column in sql server
SQL
0 vote219 views1 answer
Report in database
SQL
1 vote203 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote203 views1 answer
Not between mysql
SQL
1 vote205 views1 answer
How to find median of a column sql
SQL
0 vote209 views1 answer
Oracle sql number to varchar2
SQL
0 vote197 views1 answer
Postgresql create table with boolean column
SQL
13 votes200 views6 answers
Current date sql
SQL
0 vote230 views1 answer
Generate sql from specific migration ef core
SQL
0 vote215 views1 answer
Stored procedures example
SQL