On Thu, Mar 27, 2008 at 11:05 PM, ajcity <[EMAIL PROTECTED]> 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. > >
Have you looked at "pg_dump -t" http://www.postgresql.org/docs/8.2/static/app-pgdump.html Joey
