すべてのユーザテーブルのトリガについて、トリガ名と定義を調べるSQL - Qiita

SELECT n.nspname || '.' || c.relname AS table, t.tgname AS trigger, pg_get_triggerdef(t.oid, true) AS definition FROM pg_trigger t, pg_class c, pg_namespace n WHERE t.tgrelid = c.oid AND c.relnamespace = n.oid AND c.relkind = 'r' AND n.nspname <> 'pg_catalog' AND n.nspname <> 'information_schema' AND n.nspname !~ '^pg_toast' ORDER BY n.nspname, c.relname, t.tgname;