How do I temporarily disable triggers in PostgreSQL?

postgresql triggers bulkinsert

David Schmitt · Oct 15, 2010 · Viewed 124.6k times · Source

I'm bulk loading data and can re-calculate all trigger modifications much more cheaply after the fact than on a row-by-row basis.

How can I temporarily disable all triggers in PostgreSQL?

Answer

Alternatively, if you are wanting to disable all triggers, not just those on the USER table, you can use:

SET session_replication_role = replica;

This disables triggers for the current session.

To re-enable for the same session:

SET session_replication_role = DEFAULT;