On Mon, 1 Dec 2003, Jeff wrote: > On Mon, 1 Dec 2003 15:47:47 +0530 > "Kamalraj Singh Madhan" <[EMAIL PROTECTED]> wrote: > > 4. If you are not using 7.4 and using pg_dump, there isn't much you can > do about adding foreign keys going stupidly slow :(
You can take a schema dump and a separate data only dump where the latter specifies --disable-triggers which should disable the checks when the data is being added. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])