Answers for "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>'

Posted by: Guest on October-25-2021

Code answers related to "list all functions and procedures in postgres query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "list all functions and procedures in postgres query"

Code answers related to "list all functions and procedures in postgres query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "list all functions and procedures in postgres query"

Code answers related to "list all functions and procedures in postgres query"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us