paulrjones··on Bulk loading into PostgreSQL: Options and comparisonPostgres allows for deferring constraints, so you can do an alter command at the start to defer them, then upon commit all of the foreign keys are checked. Makes it hugely easier to load when you don’t need to do it in dependency order.