Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 27 Mar 2008 23:05:02 -0700 (PDT)
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.
- Follow-Ups:
- Re: Need help on how to backup a table
- From: Adam Rich
- Re: Need help on how to backup a table
- From: Joey K.
- Re: Need help on how to backup a table
- Prev by Date: Re: Using tables in other PostGreSQL database
- Next by Date: Re: table of US states' neighbours
- Previous by thread: Reminder: Google Summer of Code deadline 72 hours away!
- Next by thread: Re: Need help on how to backup a table
- Indexes: