Re: How to use the COPY command

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Low Kian Seong <postgresql_low(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: How to use the COPY command
Date: 2005-04-19 06:07:49
Message-ID: 17964.1113890869@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Low Kian Seong <postgresql_low(at)yahoo(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Low Kian Seong 2005-04-19 06:48:38 Re: How to use the COPY command
Previous Message Low Kian Seong 2005-04-19 05:15:52 How to use the COPY command