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
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
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
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 S
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,