Brian McCane <[EMAIL PROTECTED]> writes: > How can I list the triggers on a specific table?
select * from pg_trigger where tgrelid = (select oid from pg_class where relname = 'foo'); This table is documented now in the 7.2 documentation; see http://developer.postgresql.org/docs/postgres/catalog-pg-trigger.html regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
