Postgres Pro
Downloads
Home   >   mailing lists

Re: How to use the COPY command - Mailing list pgsql-novice

From Tom Lane
Subject Re: How to use the COPY command
Date
Msg-id 17964.1113890869@sss.pgh.pa.us
Whole thread Raw
In response to How to use the COPY command  (Low Kian Seong <postgresql_low@yahoo.com>)
List pgsql-novice
Tree view 
Low Kian Seong <postgresql_low@yahoo.com> writes:
> How do I use the copy command to copy a whole database
> onto a system file so that i can use the createdb with
> the -T flag to re-create the database on another
> system ?

I think you are looking for pg_dump, not COPY.

            regards, tom lane

pgsql-novice by date:

Previous
From: Low Kian Seong
Date:
Subject: How to use the COPY command
Next
From: Low Kian Seong
Date:
Subject: Re: How to use the COPY command