/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

8 votes138 views3 answers
Alter table auto_increment
SQL
1 vote134 views1 answer
Sql auto date
SQL
0 vote153 views1 answer
Laravel migration sql dump
SQL
0 vote146 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
5 votes147 views1 answer
Commentaire table oracle
SQL
2 votes154 views1 answer
Mysql id of inserted row
SQL
0 vote218 views1 answer
How to update random rows in sql
SQL
0 vote147 views1 answer
Mysql order by rand limit 1 really slow
SQL
0 vote161 views1 answer
Mysql persistence.xml
SQL
1 vote139 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL