/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 vote122 views1 answer
Timestamp(0) postgresql
SQL
4 votes156 views3 answers
Postgres drop all tables
SQL
0 vote122 views1 answer
Declare date variable sql
SQL
0 vote134 views1 answer
Soql queries for not contact related account records in salesforce
SQL
1 vote133 views1 answer
Mysql select if empty result
SQL
3 votes134 views1 answer
Get current month last date in sql server
SQL
1 vote121 views1 answer
Mysql drop key
SQL
-1 vote132 views1 answer
Window functions in sql
SQL
-1 vote132 views1 answer
Export mysql table to file
SQL
16 votes140 views3 answers
Jwt secret key generator laravel
SQL