Re: [GENERAL] pg_dump behaves differently for different archive formats

2013-12-16 Thread Tom Lane
Albe Laurenz writes: > Restoring a "plain format" dump and a "custom format" dump of > the same database can lead to different results: > pg_dump organizes the SQL statements it creates in "TOC entries". > If a custom format dump is restored with pg_restore, all > SQL statements in a TOC entry wi

[GENERAL] pg_dump behaves differently for different archive formats

2013-12-16 Thread Albe Laurenz
Restoring a "plain format" dump and a "custom format" dump of the same database can lead to different results: pg_dump organizes the SQL statements it creates in "TOC entries". If a custom format dump is restored with pg_restore, all SQL statements in a TOC entry will be executed as a single comma