On Sep 25, 2006, at 9:49 AM, Bill Moran wrote:
In response to "Bobby Gontarski" <[EMAIL PROTECTED]>:
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 [EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
