Thread: pg dump restore

pg dump restore

From
Edgars
Date:
Hi all!

such an easy question - i've dumped one of my postgresql databases in
one file names 'first'. So now i want to put the structure of this old
DB to another one named 'second'. How should i proceed  with this?

Thanx in advance!
Edgars

Re: pg dump restore

From
"Antonis Antoniou"
Date:
Edgars wrote:

> Hi all!
>
> such an easy question - i've dumped one of my postgresql databases in
> one file names 'first'. So now i want to put the structure of this old
> DB to another one named 'second'. How should i proceed  with this?

I think your question is not clear
If the 'first' is a database name then you will have to create a new
database (createdb) 'second'.
http://www.postgresql.org/docs/7.4/static/backup.html