/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 vote195 views1 answer
Mysql how to reset primary key
SQL
12 votes185 views2 answers
Delete entries in postgresql
SQL
0 vote195 views1 answer
Tsql cmd exec script from file
SQL
0 vote193 views1 answer
What is ssrs and ssis in sql server
SQL
5 votes214 views1 answer
Oracle generate list of dates in between a date range
SQL
0 vote182 views1 answer
Mysql show category once count how many products
SQL
0 vote192 views1 answer
Mysql terminal list table
SQL
0 vote224 views1 answer
Sqlalchemy empty table
SQL
11 votes185 views4 answers
Query DISTINCT
SQL
0 vote201 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL