/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 vote152 views1 answer
Full syntax inner join
SQL
0 vote169 views1 answer
How to install postgresql on wsl
SQL
1 vote356 views1 answer
Postgres upgrade to superuser
SQL
0 vote175 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote205 views1 answer
Postgres docs /copy metacomand
SQL
6 votes191 views1 answer
To count number of rows in SQL table
SQL
0 vote181 views1 answer
T-SQL Never ending DELETE
SQL
0 vote160 views1 answer
Psql attribute cannot login
SQL
4 votes182 views1 answer
W3schools create table
SQL
0 vote213 views1 answer
How to pass list as parameter in SQL query
SQL