You want a list of triggers and the functions they call on certain tables.
To see the triggers and functions on tables foo_xxx use:
SELECT cl.relname,tr.tgname AS triggername, tr.tgenabled, fn.proname AS func_name FROM pg_trigger AS tr, pg_class AS cl, pg_proc AS fn WHERE tr.tgrelid=cl.oid AND tr.tgfoid=fn.oid AND cl.relname ˜ '^foo%'; |