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.