Need help on how to backup a table

From: ajcity <victor(dot)aluko(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Need help on how to backup a table
Date: 2008-03-28 06:05:02
Message-ID: 16346381.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi all,
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.

Victor
--
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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2008-03-28 06:26:46 Re: PostgreSQL Replication with read-only access to standby DB
Previous Message Swaminathan Saikumar 2008-03-28 05:29:37 Re: Using tables in other PostGreSQL database