Skip site navigation (1) Skip section navigation (2)

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: (view raw or whole 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.

View this message in context:
Sent from the PostgreSQL - general mailing list archive at


pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group