Postgres Pro
Downloads
Home   >   mailing lists

Re: Dumping a table from one database and adding it to another - Mailing list pgsql-general

From James B. Byrne
Subject Re: Dumping a table from one database and adding it to another
Date
Msg-id 55552.216.185.71.25.1291324610.squirrel@webmail.harte-lyne.ca
Whole thread Raw
In response to Re: Dumping a table from one database and adding it to another  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Tree view 
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 channel          ***
James B. Byrne                mailto:ByrneJB@Harte-Lyne.ca
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Dumping a table from one database and adding it to another
Next
From:
Date:
Subject: Re: Looking for auto starting procedures