pg_restore : change schema

This is a multi-part message in MIME format.

------_=_NextPart_001_01CAD17D.D2B37BF8
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi

Imagine I have used pg_dump to backup a given single schema.

Is there any feature in pg_restore (8.4) that would allow to restore =
this schema in a schema with another name ?

Thanks

--

Christophe Dor=E9


------_=_NextPart_001_01CAD17D.D2B37BF8
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable




charset=3Diso-8859-1">
6.5.7654.12">

FACE=3D"Calibri">Hi

Imagine I have =
used pg_dump to backup a given single schema.

Is there any =
feature in pg_restore (8.4) that would allow to =
restore this =
schema in a schema with another name ?

FACE=3D"Calibri">Thanks

LANG=3D"en-us"> FACE=3D"Calibri">-- LANG=3D"en-us">

LANG=3D"en-us"> LANG=3D"fr-fr">Christophe =
Dor=E9 LANG=3D"en-us">

Re: pg_restore : change schema

Christophe Dore writes:

> Imagine I have used pg_dump to backup a given single schema.
> Is there any feature in pg_restore (8.4) that would allow to restore this
> schema in a schema with another name ?


I think there isn't. If the pg_dump is ASCII and the file is small enough
you could edit it.

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: pg_restore : change schema

Julio Leyva writes:

> What about=A0 alter schema=A0 ?

How would that help?

If I understand correctly, the original poster is trying to do something=20
like:

Source DB
schema1.table1

And restore it to
schema2.table1

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: pg_restore : change schema

Well, that would work if the schema, when restored, is free. If not, you'd =
like to set the schema name in which you restore before restoring.

When you use Oracle, you can, using exp/imp, change the schema you restore =
in by setting properly the program arguments. I understand that this is not=
possible with postgres, and this would be a nice feature.

Regards

--

Christophe Dor=E9

-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql=
..org] On Behalf Of Francisco Reyes
Sent: jeudi 1 avril 2010 22:20
To: Julio Leyva
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] pg_restore : change schema

Julio Leyva writes:

> What about=A0 alter schema=A0 ?

How would that help?

If I understand correctly, the original poster is trying to do something=20
like:

Source DB
schema1.table1

And restore it to
schema2.table1

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin