/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 vote109 views1 answer
Left join vs inner join performance
SQL
0 vote161 views1 answer
Postgres rename database
SQL
-1 vote107 views2 answers
Full join sql
SQL
6 votes100 views2 answers
WHERE value IS sql
SQL
0 vote107 views1 answer
Bigquery declare
SQL
1 vote87 views1 answer
Can we drop a primary key
SQL
0 vote98 views1 answer
Print orcale
SQL
0 vote103 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote111 views8 answers
Convert sql query to linq online
SQL
31 votes111 views4 answers
Mysql grant execute
SQL