Выключить:
   UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname"='tablename';

Включить:
   UPDATE pg_class SET reltriggers = (
      SELECT count(*) FROM pg_trigger where pg_class.oid = tgrelid)
      WHERE relname = 'table name';