Change foreign key constraints to be deferrable in PostgreSQL DDL (and possibly others?)

[ekorchmar]

Would it make sense to introduce "DEFERRABLE" keyword when creating foreign key constraints in these tables? It simplifies process of actually populating tables from Athena downloads or making local changes, without having to drop and re-create constraints.

file in question

Links:

• https://www.postgresql.org/docs/current/sql-set-constraints.html