/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 vote385 views1 answer
How to check common records in 2 table
SQL
2 votes283 views2 answers
Function in sql
SQL
0 vote299 views1 answer
Pl sql constraint user function
SQL
0 vote319 views1 answer
SQL SERVER xquery count child nodes
SQL
2 votes308 views2 answers
How to check data type in sql server
SQL
0 vote305 views1 answer
Postgres : ERROR: division by zero
SQL
4 votes317 views4 answers
What is primary key
SQL
0 vote380 views1 answer
Mysql get longest string in column
SQL
2 votes313 views3 answers
Copy data from one table column to another table column in sql
SQL
0 vote301 views2 answers
Close external port 3306 with iptables
SQL