"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