All information for procedures and triggers in PostgreSQL is stored in the pg_proc table in the system catalog. Here is how to get some of the more useful information.