On Tue, 2005-05-31 at 15:03, thomas wrote:
> hi there,
>
> i'm wondering, if i can use pg_dump to move only one schema of a db from
> the one server, intoan other schema on the other server?
>
> for example:
>
> Server A:
> Database: xyz_test
> Schema: 123
>
> Server B:
> Database: xyz_prod
> Schema: 999
>
>
> The tablenames and so on are equal. and i wan't to transfer the data
> with it. is it possible? and how? today i played a little bit with it,
> but could not find a proper way with it. the description in the docu
> didn't helped me either. any solution anyone?
To dump a certain schema, use the -n switch, then edit / sed the output
to change the schemaname to something else and load it back into the
other database with psql.