/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

25 votes433 views5 answers
Mysql replace text
SQL
2 votes384 views2 answers
Sqlalchemy return id after insert
SQL
0 vote346 views1 answer
Oracle allow space to user
SQL
0 vote343 views1 answer
Count characters of string mysql
SQL
4 votes360 views3 answers
Sql drop primary key
SQL
0 vote338 views1 answer
Sqlalchemy case insensitive like
SQL
0 vote334 views1 answer
SQL Server modify_timestamp trigger
SQL
3 votes434 views4 answers
Sql interview questions
SQL
0 vote361 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote373 views1 answer
Oracle sql alter view add column
SQL