--- 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
> > onto a system file so that i can use the createdb
> > 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
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.
pgsql-novice by date
|Next:||From: Bruno Wolff III||Date: 2005-04-19 11:44:28|
|Subject: Re: How to use the COPY command|
|Previous:||From: Tom Lane||Date: 2005-04-19 06:07:49|
|Subject: Re: How to use the COPY command |