Re: [GENERAL] What pg_restore does to a non-empty target database

2008-01-14 Thread Ken Winter
Based on Tom Lane's response, here is version 2 of my attempt to document what pg_restore does to a target database that already contains objects. Version 2 has been limited to the case where pg_dump was run with the --column-inserts option and pg_restore is run with the --clean option. Also, w

Re: [GENERAL] What pg_restore does to a non-empty target database

2008-01-13 Thread Tom Lane
"Ken Winter" <[EMAIL PROTECTED]> writes: > I need to understand, in as much detail as possible, the results that will > occur when pg_restore restores from an archive file into a target database > that already contains some database objects. I can't find any reference > that spells this out. (The

[GENERAL] What pg_restore does to a non-empty target database

2008-01-13 Thread Ken Winter
I need to understand, in as much detail as possible, the results that will occur when pg_restore restores from an archive file into a target database that already contains some database objects. I can't find any reference that spells this out. (The PG manual isn't specific enough.) Instead of ju