Answers for "list postgres procedures"

SQL
0

postgres list all stored procedures query

select n.nspname as schema,
       p.proname as procedure
from pg_proc p
join pg_namespace n on p.pronamespace = n.oid
where n.nspname not in ('pg_catalog', 'information_schema')
	and p.prokind = 'p'
Posted by: Guest on May-15-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language