/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

0 vote201 views1 answer
Group by 15 minute interval sql server
SQL
0 vote185 views2 answers
Identity column in sql server
SQL
2 votes202 views3 answers
Postgres json to string
SQL
8 votes183 views1 answer
Oracle search code in packages
SQL
0 vote191 views1 answer
Mysql sum per week
SQL
0 vote178 views1 answer
How to reset AI in sql
SQL
0 vote194 views2 answers
Dbms interview questions
SQL
0 vote154 views1 answer
Month mysql
SQL
0 vote184 views1 answer
Postgres enumerated type
SQL
0 vote202 views1 answer
Sql sum if
SQL