Rod Taylor <[EMAIL PROTECTED]> writes: > Well.. the second one will be much slower when the foreign keys verify. > Primary, unique constraints I'll buy in the create statement. Check > constraints and defaults are a little fuzzier.
FK, primary, and unique constraints are already split out from the CREATE TABLE for performance reasons. We could think about folding them back in in a schema-only dump, but in a full dump I don't think it's negotiable --- you really want to load the table data before you install these constraints. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])