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 SECURE
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