Обсуждение: copy db1 to db2

Basically I need to copy db1 to db2 which I create manually. How do I do that, I tried pg_dump pg_restore but I get
someerrors with foreign key restraint... 

In response to "Bobby Gontarski" <Gontarski@seznam.cz>:

> Basically I need to copy db1 to db2 which I create manually. How do I
> do that, I tried pg_dump pg_restore but I get some errors with foreign
> key restraint...

You can use create database with db1 as the template.  See the docs for
details.

--
Bill Moran
Collaborative Fusion Inc.

On Sep 25, 2006, at 9:49 AM, Bill Moran wrote:
> In response to "Bobby Gontarski" <Gontarski@seznam.cz>:
>> Basically I need to copy db1 to db2 which I create manually. How do I
>> do that, I tried pg_dump pg_restore but I get some errors with
>> foreign
>> key restraint...
>
> You can use create database with db1 as the template.  See the docs
> for
> details.

But if you're getting foreign key constraint errors, you probably
have some other issue that you should figure out.

What version is this anyway?
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)