Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Need help on how to backup a table
- From: "Joey K." <pguser(at)gmail(dot)com>
- To: ajcity <victor(dot)aluko(at)gmail(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Need help on how to backup a table
- Date: Thu, 27 Mar 2008 23:39:22 -0700
On Thu, Mar 27, 2008 at 11:05 PM, ajcity <victor(dot)aluko(at)gmail(dot)com> wrote:
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.
- Follow-Ups:
- Re: Need help on how to backup a table
- From: ajcity
- Re: Need help on how to backup a table
- References:
- Need help on how to backup a table
- From: ajcity
- Need help on how to backup a table
- Prev by Date: Re: table of US states' neighbours
- Next by Date: Re: Need help on how to backup a table
- Previous by thread: Need help on how to backup a table
- Next by thread: Re: Need help on how to backup a table
- Indexes: