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)