make all constraints DEFERRABLE

gistfile1.sql

-- use this to make all constraints in "public" schema `deferrable initially immediate`
-- (edit schema name if needed)

do $$
declare
  sql text;
begin
  select into sql
    string_agg(
      'alter table ' || quote_ident(ns.nspname) || '.' || quote_ident(tb.relname)
        || ' alter constraint ' || quote_ident(conname) || ' deferrable initially immediate;'
      , ' '
    )
  from pg_constraint c
  join pg_class tb on tb.oid = c.conrelid
  join pg_namespace ns on ns.oid = tb.relnamespace
  where c.contype = 'f' and ns.nspname in ('public');
  raise notice 'sql: %', sql;
  execute sql;
end;
$$ language plpgsql;