Managing Triggers

1. Dropping Trigger

DROP TRIGGER IF EXISTS orders_audit ON orders;

ALTER TABLE orders DISABLE TRIGGER orders_audit;

ALTER TABLE orders ENABLE TRIGGER orders_audit;

ALTER TABLE orders DISABLE TRIGGER ALL;     -- includes RI triggers
ALTER TABLE orders DISABLE TRIGGER USER;    -- user-defined only

Warning: Disabling ALL also disables foreign-key triggers; data integrity may break.

ALTER TABLE orders ENABLE TRIGGER ALL;

ALTER TABLE orders ENABLE ALWAYS TRIGGER audit_trg;

ALTER TABLE orders ENABLE REPLICA TRIGGER audit_trg;
SET session_replication_role = 'replica';   -- session-level switch

Order	Detail
Within same timing	Alphabetical by trigger name
BEFORE	Run before constraints
AFTER	Run after constraints

ALTER TRIGGER orders_audit ON orders RENAME TO trg_orders_audit;

SELECT pg_get_triggerdef(oid) FROM pg_trigger WHERE tgname='trg_orders_audit';