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

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 (view raw or flat)
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

pgsql-novice by date

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

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