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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7654.12">
<TITLE>pg_restore : change schema</TITLE>
</HEAD>
<BODY>


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



</BODY>
</HTML>
------_=_NextPart_001_01CAD17D.D2B37BF8--

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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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
like:

Source DB
schema1.table1

And restore it to
schema2.table1

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

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 [at] postgresql.org [mailto:pgsql-admin-owner [at] postgresql=
..org] On Behalf Of Francisco Reyes
Sent: jeudi 1 avril 2010 22:20
To: Julio Leyva
Cc: pgsql-admin [at] 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
like:

Source DB
schema1.table1

And restore it to
schema2.table1

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

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

pg_restore : change schema

Re: pg_restore : change schema

Re: pg_restore : change schema

Re: pg_restore : change schema