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

Re: How to use the COPY command

From: Low Kian Seong <postgresql_low(at)yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: How to use the COPY command
Date: 2005-04-19 06:48:38
Message-ID: 20050419064838.31107.qmail@web31613.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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
> 

When I use pg_dump, it complaints when i try to do
this :

createdb dbname -T /path/to/dump/file

What must the format of the dump file be in order for
the above command to work ? 


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Helps protect you from nasty viruses. 
http://promotions.yahoo.com/new_mail

Responses

pgsql-novice by date

Next:From: Bruno Wolff IIIDate: 2005-04-19 11:44:28
Subject: Re: How to use the COPY command
Previous:From: Tom LaneDate: 2005-04-19 06:07:49
Subject: Re: How to use the COPY command

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