From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
---|---|
To: | thomas <tr75(at)gmx(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: using pg_dump to dump only a schema? |
Date: | 2005-05-31 21:01:31 |
Message-ID: | 1117573291.20484.44.camel@state.g2switchworks.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2005-05-31 21:56:56 | Re: CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT |
Previous Message | Gianni Mariani | 2005-05-31 20:22:52 | Re: Accessing PostgreSQL from C++ |