I am trying to backup a large table with about 6 million rows. I want to
export the data from the table and be able to import it into another table
on a different database server (from pgsql 8.1 to 8.2). I need to export the
data through SQL query 'cause I want to do a gradual backup.
Does pgsql have a facility for this?
Thanks in advance for your reply.
View this message in context: http://www.nabble.com/Need-help-on-how-to-backup-a-table-tp16346381p16346381.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
pgsql-general by date
|Next:||From: Greg Smith||Date: 2008-03-28 06:26:46|
|Subject: Re: PostgreSQL Replication with read-only access to standby
|Previous:||From: Swaminathan Saikumar||Date: 2008-03-28 05:29:37|
|Subject: Re: Using tables in other PostGreSQL database|