/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

6 votes246 views1 answer
Allsource oracle
SQL
5 votes274 views1 answer
Sql add column after another
SQL
0 vote262 views1 answer
Postgresql interview questions
SQL
7 votes235 views2 answers
Create mysql user
SQL
1 vote279 views1 answer
Oracle see column type
SQL
4 votes260 views2 answers
Tsql utf to local time
SQL
5 votes240 views1 answer
How to check nls timestamp format in oracle
SQL
0 vote248 views1 answer
How to put is null in where in clause
SQL
0 vote242 views1 answer
Disableforiegn key check
SQL
0 vote242 views1 answer
Renommer table sql
SQL