Postgres - 8.3 Default Tables

If you want to see the list of available procedures,
run the following query.

select * from pg_proc


If you want to see the list of available triggers,

run the following query.

select * from pg_trigger

If you want to see the list of available datatypes,

run the following query.

select * from pg_type