/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 vote230 views3 answers
Postgresql crete view
SQL
0 vote260 views1 answer
Mysql get hour from datetime
SQL
0 vote237 views1 answer
Two inner joins sql
SQL
0 vote214 views1 answer
Import sql mysql ubuntu
SQL
1 vote213 views1 answer
Firebase bigquery cloud message
SQL
11 votes242 views1 answer
Sql query to find duplicates in column
SQL
1 vote232 views1 answer
How refresh navicat tables to see new tables
SQL
0 vote262 views2 answers
Add colum in sql
SQL
0 vote239 views1 answer
Utiliser sql ligne de commande
SQL
5 votes222 views3 answers
Truncate function in sql oracle
SQL