Author: techfox9
PostgreSQL list of triggers ..
Monday, November 21st, 2011 @ 1:05 am
SELECT relname, tgname, usename FROM ( pg_trigger JOIN pg_class ON (tgrelid = pg_class.oid) JOIN pg_proc ON (tgfoid = pg_proc.oid) JOIN pg_user ON (relowner = pg_user.usesysid) ) WHERE tgisinternal = FALSE [ and usename = 'user' ]