/SQL/Postgres list all stored procedures query

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'

Source: dataedo.com

Similar codes

2 votes128 views1 answer
Oracle sql day of month from date
SQL
0 vote155 views1 answer
Sql server phone constraint
SQL
0 vote157 views1 answer
Mysql installer no packages found
SQL
0 vote134 views2 answers
Drop check constraint in ms sql
SQL
2 votes152 views1 answer
Query to find table size in oracle 12c
SQL
0 vote139 views1 answer
Change role postgres
SQL
7 votes134 views4 answers
Lowest salary in sql
SQL
0 vote199 views1 answer
How to get number of months between 2 dates sql server
SQL
3 votes131 views1 answer
Oracle wait
SQL
12 votes140 views1 answer
How to change the value of a table in sql
SQL