Re: Copy content from dbs

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 content on the same
> machine - just with the different name?

pg_dump: http://www.postgresql.org/docs/8.1/static/app-pgdump.html

Thomas