pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_restore : change schema
4+ messages / 2 participants
[nested] [flat]
* pg_restore : change schema
@ 2010-04-01 09:29 Christophe Dore <c.dore@castsoftware.com>
0 siblings, 1 reply; 4+ messages in thread
From: Christophe Dore @ 2010-04-01 09:29 UTC (permalink / raw)
To: pgsql-admin
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é
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_restore : change schema
@ 2010-04-01 15:06 Francisco Reyes <lists@stringsutils.com>
parent: Christophe Dore <c.dore@castsoftware.com>
0 siblings, 1 reply; 4+ messages in thread
From: Francisco Reyes @ 2010-04-01 15:06 UTC (permalink / raw)
To: Christophe Dore <c.dore@castsoftware.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_restore : change schema
@ 2010-04-01 20:20 Francisco Reyes <lists@stringsutils.com>
parent: Francisco Reyes <lists@stringsutils.com>
0 siblings, 1 reply; 4+ messages in thread
From: Francisco Reyes @ 2010-04-01 20:20 UTC (permalink / raw)
To: Julio Leyva <jcleyva@hotmail.com>; +Cc: pgsql-admin
Julio Leyva writes:
> What about alter schema ?
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_restore : change schema
@ 2010-04-02 06:03 Christophe Dore <c.dore@castsoftware.com>
parent: Francisco Reyes <lists@stringsutils.com>
0 siblings, 0 replies; 4+ messages in thread
From: Christophe Dore @ 2010-04-02 06:03 UTC (permalink / raw)
To: Francisco Reyes <lists@stringsutils.com>; Julio Leyva <jcleyva@hotmail.com>; +Cc: 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é
-----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 alter schema ?
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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2010-04-02 06:03 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-04-01 09:29 pg_restore : change schema Christophe Dore <c.dore@castsoftware.com>
2010-04-01 15:06 ` Francisco Reyes <lists@stringsutils.com>
2010-04-01 20:20 ` Francisco Reyes <lists@stringsutils.com>
2010-04-02 06:03 ` Christophe Dore <c.dore@castsoftware.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox