/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 vote208 views1 answer
How to reset the database value in SQL server
SQL
2 votes197 views1 answer
Oracle cpu per session
SQL
2 votes214 views1 answer
Postgresql create schema in specific database
SQL
0 vote236 views1 answer
Delete a temporary table mysql
SQL
10 votes248 views2 answers
What is database
SQL
0 vote243 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
12 votes198 views2 answers
Insert multiple rows from another table sql
SQL
-1 vote256 views1 answer
Difference berween database and data base management system
SQL
0 vote205 views3 answers
Mysql delete if not in another table
SQL
0 vote213 views1 answer
Select odd records sql
SQL