すべてのユーザテーブルのトリガについて、トリガ名と定義を調べるSQLは、
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;