Stored procedures or simply put procedures are just SQL codes that can be saved for later use. There are few ways you could list them though, found below.
List all procedures using SQL query
SELECT nspname, proname
FROM pg_catalog.pg_namespace ns
JOIN pg_catalog.pg_proc pr
ON pronamespace = ns.oid
WHERE nspname = 'public'
ORDER BY proname;
List all procedures using PSQL
View procedure code
Other potentially useful PostgreSQL listing queries:
On a side note, follow our official channel on Telegram.