using pg_dump to dump only a schema?

From: thomas <tr75(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: using pg_dump to dump only a schema?
Date: 2005-05-31 20:03:36
Message-ID: 429CC318.5040009@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gianni Mariani 2005-05-31 20:22:52 Re: Accessing PostgreSQL from C++
Previous Message Tom Lane 2005-05-31 19:43:56 Re: CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT