ACID compliance (Atomicity, Consistency, Isolation, Durability) Advanced data types (JSON, XML, arrays, ranges, geospatial) Full-text search Foreign data wrappers High availability and disaster recovery Beyond SQL: PostgreSQL offers additional features beyond standard SQL: Stored procedures: Reusable block...
So yeah, in your situation, it may well be best. You could always write some simple validation select statements to select any child data in a child table that doesn't have an entry in its parent table - run them after your data has been restored. ...