Re: Copy content from dbs - Mailing list pgsql-general

From Guido Neitzer
Subject Re: Copy content from dbs
Date
Msg-id 16929CD8-5365-4067-B1C6-378658C6AAC5@pharmaline.de
Whole thread Raw
In response to Re: Copy content from dbs  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
On 14.06.2006, at 14:12 Uhr, A. Kretschmer wrote:

>> Is there an easy way to copy the content including the table
>> structure,
>> indexes and so on from one db to another?
>
> Create the new db with the old db as template.

Thanks, but as far as I can see, I have to disconnect all clients
from the production db to do this and this wasn't an option.

I forgot to mention that. The pg_dump way is fine for me.

cug

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Copy content from dbs
Next
From: Jan Behrens
Date:
Subject: Re: COLLATE