Brian McCane wrote:
> How can I list the triggers on a specific table?
Just as I was typing this I noticed Tom already replied. Just incase you
want to know all triggers referencing the table in addition to those on it
(eg. foreign key constraints).
SELECT t.oid, t.*
FROM pg_trigger t, pg_class c
WHERE where c.oid in (t.tgrelid, t.tgconstrrelid)
AND c.relname = 'foo';