Postgres Pro
Downloads
Home   >   mailing lists

Need help on how to backup a table - Mailing list pgsql-general

From ajcity
Subject Need help on how to backup a table
Date
Msg-id 16346381.post@talk.nabble.com
Whole thread Raw
Responses Re: Need help on how to backup a table  ("Joey K." <pguser@gmail.com>)
Re: Need help on how to backup a table  ("Adam Rich" <adam.r@sbcglobal.net>)
List pgsql-general
Tree view 
 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.

pgsql-general by date:

Previous
From: "Swaminathan Saikumar"
Date:
Subject: Re: Using tables in other PostGreSQL database
Next
From: Michael Fuhr
Date:
Subject: Re: table of US states' neighbours