Re: Creating new database - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Creating new database
Date
Msg-id dcc563d10911180739r4d987f52n8c47954f884a1459@mail.gmail.com
Whole thread Raw
In response to Re: Creating new database  (Joao Ferreira gmail <joao.miguel.c.ferreira@gmail.com>)
Responses Re: Creating new database  (Joao Ferreira gmail <joao.miguel.c.ferreira@gmail.com>)
List pgsql-general
On Wed, Nov 18, 2009 at 8:12 AM, Joao Ferreira gmail
<joao.miguel.c.ferreira@gmail.com> wrote:
> I'dd suggest:
>
> pgdumpall --clean > dump.sql

I'd think he'd be much better off with pg_dump, not pg_dumpall.

pg_dump srcdb | psql destdb

you can add -s as a pg_dump switch if all you want is the schema.

pgsql-general by date:

Previous
From: Malcolm Warren
Date:
Subject: [Fwd: Re: Creating new database]
Next
From: Joao Ferreira gmail
Date:
Subject: Re: Creating new database