Re: [GENERAL] turning of referential integrity

If you are using pg_dump, you probably should be fine if you're restoring a full database, because it should place the constraints in after the data is loaded. If you do a data only dump, there is code in the dump at the very top and bottom to disable and reenable the constraints and that should

[GENERAL] turning of referential integrity

Hi All, I am wondering is there any way to turning off referential integrity without using SET CONSTRAINTS and create table with DEFERRABLE for database restore purpose? TIA. --Mursalin.