/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 vote372 views1 answer
Rows, INSERT INTO, Returning
SQL
0 vote365 views2 answers
How to create a table from another table in sql derby
SQL
0 vote353 views1 answer
Commit transaction sql
SQL
0 vote354 views1 answer
Select all tables linked server sql
SQL
0 vote369 views1 answer
Sql server concat null
SQL
0 vote365 views1 answer
Mysql update table from select on another table
SQL
17 votes378 views4 answers
Postgres list users
SQL
0 vote437 views1 answer
Sql datum formatieren
SQL
3 votes364 views2 answers
Mysql create database
SQL
0 vote375 views1 answer
Alter check command
SQL