/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

1 vote323 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
5 votes342 views1 answer
Oracle source query
SQL
5 votes296 views3 answers
MySql get fields of table
SQL
0 vote299 views1 answer
Mysql Digital Ocean connection problems
SQL
0 vote289 views1 answer
Online sql testing tool
SQL
1 vote248 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
0 vote283 views4 answers
How to drop all tables in sql
SQL
15 votes283 views2 answers
How to know the username of postgresql
SQL
0 vote361 views1 answer
Postgres extract number from string
SQL
5 votes281 views2 answers
Oracle tables with column name
SQL