In general, you are always going to want your triggers to fire. That's why they are there. Though special circumstances may arise where you need to temporarily disable them. Use
> set session_replication_role = 'replica';
SETBy changing the
replication role
from origin to
replica you are essentially disabling all non-replica triggers across the
database (for that session). When you are done, you can simply set the
replication role back so that normal trigger behavior can resume
> set session_replication_role = 'origin';
SETA more direct and fine-grained approach to disabling triggers is to use an
alter table command that targets a specific trigger.
h/t Jack Christensen