using pg_dump to dump only a schema? - Mailing list pgsql-general

From thomas
Subject using pg_dump to dump only a schema?
Date
Msg-id 429CC318.5040009@gmx.net
Whole thread Raw
Responses Re: using pg_dump to dump only a schema?
List pgsql-general
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?

thanx in advance!

bye,
thomas


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT
Next
From: Gianni Mariani
Date:
Subject: Re: Accessing PostgreSQL from C++