/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

2 votes283 views1 answer
Oracle drop sequence if exists
SQL
0 vote302 views1 answer
Get only one row in mysql
SQL
0 vote320 views1 answer
Eliminate zero from integer mysql
SQL
10 votes283 views4 answers
How to alter table name in mysql
SQL
0 vote299 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote276 views1 answer
Postgres reorder columns
SQL
10 votes297 views2 answers
Tsql merge example
SQL
2 votes284 views1 answer
Removing view
SQL
0 vote351 views1 answer
Stop and start mysql
SQL
0 vote296 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL