/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 vote133 views1 answer
How to install sql in anaconda
SQL
1 vote146 views1 answer
Show table status command in mysql
SQL
10 votes117 views3 answers
Join multiple tables sql
SQL
1 vote183 views1 answer
Mysql is odd
SQL
0 vote135 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote131 views1 answer
Select only one row sql
SQL
7 votes142 views1 answer
Grant schema permissions postgres
SQL
0 vote329 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote131 views1 answer
Implizite joins sql
SQL
0 vote127 views1 answer
Sql server select furst day of current year
SQL