> How can I get a listing of all the stored procedures and triggers for my
> database?
>
Have a look at the tables pg_proc and pg_trigger from the system catalog
(aka "data dictionary").
It is documented in the "Developer's Guide", chapter 3 "System Catalog".
Christoph Dalitz