/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

1 vote170 views2 answers
Find a column in all tables mysql
SQL
0 vote239 views1 answer
Cannot start database server xampp mac os
SQL
0 vote177 views1 answer
Selecting duplicates
SQL
26 votes175 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote202 views1 answer
Alter domain sql
SQL
-1 vote209 views1 answer
How to Activate the database
SQL
1 vote180 views1 answer
Delete from inner join sql
SQL
3 votes166 views1 answer
Oracle list dates without weekends
SQL
3 votes179 views2 answers
Postgres alter table owner
SQL
15 votes370 views2 answers
How to sort names in alphabetical order in sql
SQL