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.