Re: [GENERAL] copy db1 to db2

2006-09-26 Thread Jim Nasby
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

Re: [GENERAL] copy db1 to db2

2006-09-25 Thread Bill Moran
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

Re: [GENERAL] copy db1 to db2

2006-09-25 Thread Matthias . Pitzl
AIL PROTECTED] On Behalf Of > Bobby Gontarski > Sent: Sunday, September 24, 2006 5:21 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] 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_r

[GENERAL] copy db1 to db2

2006-09-24 Thread Bobby Gontarski
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... ---(end of broadcast)--- TIP 4: Have you searched our list archives? http:/