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'; ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
