[GENERAL] Copy content from dbs

2006-06-14 Thread Guido Neitzer
Hi. Is there an easy way to copy the content including the table structure, indexes and so on from one db to another? Let's say I have a production db called db_production and want to create a development db called db_dev with exactly the same content on the same machine - just with the

Re: [GENERAL] Copy content from dbs

2006-06-14 Thread Thomas Kellerer
On 14.06.2006 13:56 Guido Neitzer wrote: Hi. Is there an easy way to copy the content including the table structure, indexes and so on from one db to another? Let's say I have a production db called db_production and want to create a development db called db_dev with exactly the same

Re: [GENERAL] Copy content from dbs

2006-06-14 Thread Guido Neitzer
On 14.06.2006, at 14:02 Uhr, Thomas Kellerer wrote: pg_dump: http://www.postgresql.org/docs/8.1/static/app-pgdump.html Found it. Thanks. I was just blind and thought, pg_dump can only re- create the db with the same name. Thanks, Guido ---(end of

Re: [GENERAL] Copy content from dbs

2006-06-14 Thread A. Kretschmer
am 14.06.2006, um 13:56:06 +0200 mailte Guido Neitzer folgendes: Hi. 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. Andreas -- Andreas Kretschmer(Kontakt: siehe Header)

Re: [GENERAL] Copy content from dbs

2006-06-14 Thread Guido Neitzer
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