Re: [SQL] paertially restoring a DB

2004-10-31 Thread Iain
Hi, What you are trying to do should be possible as far as I know. Did you use the custom format for your dump (pg_dump -Fc)? Try extracting a list of contents of the dump (pg_restore --list) option and check that for anything that might be causing you to lose that table. Comment out any offendi

[SQL] paertially restoring a DB

2004-10-31 Thread Niall Linden
i am having a problem with dump and restore. basically i have 2 databases maindb and tempdb the databases are almost the same but the main db has some extra tables which dont change. what i need to do is get all the information form the temp db and put it in the main db. the tempdb should overwri