Postgres Pro
Downloads
Home   >   mailing lists

Thread: Export

Export

From
"Jana Vasseru"
Date:
Hello,
i have two questions
a) how can i export database schema structure and data so that they can be
imported to another server - into different
database, different tablespace and with a different owner ?

b) how can i export structure of database so that SERIAL columns remain
SERIAL?

Regards,
  Jana

Re: Export

From
Tom Lane
Date:
"Jana Vasseru" <jana.vasseru@gmail.com> writes:
> a) how can i export database schema structure and data so that they can be
> imported to another server - into different
> database, different tablespace and with a different owner ?

pg_dump's --no-owner switch might help for the last.  If you want to
change tablespace names you'll probably have to edit the dump script
manually.  It might be easier to use ALTER TABLESPACE RENAME to
temporarily make the destination's tablespace configuration match
by name before you load the dump.

> b) how can i export structure of database so that SERIAL columns remain
> SERIAL?

pg_dump does not bother with the SERIAL shorthand.  It's only shorthand,
there is no functional difference.

            regards, tom lane