More info: https://github.com/tgriesser/knex/issues/1830

knexDeferAllForeignKeys.js

export default async (knex) => {
  const foreignKeys = await knex('pg_constraint')
    .select('*')
    .where('contype', '=', 'f');

  const queries = foreignKeys.map(async foreignKey => {
    const [keyData] = await knex('pg_class')
      .select('relname')
      .where('oid', '=', foreignKey.conrelid);
    
    const tableName = keyData.relname;
    
    return knex.schema.raw(`
      ALTER TABLE "${tableName}"
      ALTER CONSTRAINT ${foreignKey.conname}
      DEFERRABLE INITIALLY DEFERRED;
    `);
  });

  await Promise.all(queries);
};