[GENERAL] Dumping a table from one database and adding it to another

2010-12-02 Thread James B. Byrne
I have read the documentation respecting backups but I cannot seem to find any mention of the specific case that I wish performed. I have a pair of tables in a production database that I wish to dump and then restore to a new, different database. I can, and probably will, recreate the tables and

Re: [GENERAL] Dumping a table from one database and adding it to another

2010-12-02 Thread Adrian Klaver
On 12/02/2010 12:49 PM, James B. Byrne wrote: I have read the documentation respecting backups but I cannot seem to find any mention of the specific case that I wish performed. I have a pair of tables in a production database that I wish to dump and then restore to a new, different database. I

Re: [GENERAL] Dumping a table from one database and adding it to another

2010-12-02 Thread Adrian Klaver
On 12/02/2010 12:49 PM, James B. Byrne wrote: I have read the documentation respecting backups but I cannot seem to find any mention of the specific case that I wish performed. I have a pair of tables in a production database that I wish to dump and then restore to a new, different database. I

Re: [GENERAL] Dumping a table from one database and adding it to another

2010-12-02 Thread James B. Byrne
On Thu, December 2, 2010 15:57, Adrian Klaver wrote: a different database, using PG utilities? pg_dump -U postgres -a -t cell_per -f cell_per.sql production followed by: /usr/bin/psql -f cell_per.sql production works wonderfully. Thank you. -- *** E-Mail is NOT a SECURE

Re: [GENERAL] Dumping a table from one database and adding it to another

2010-12-02 Thread Brent Wood
Brent Wood DBA/GIS consultant NIWA, Wellington New Zealand James B. Byrne 12/03/10 12:56 PM I have read the documentation respecting backups but I cannot seem to find any mention of the specific case that I wish performed. Hi James, pg_dump can take arguments to dump a specified table, the