From: Francisco Reyes <lists@stringsutils.com>
To: Julio Leyva <jcleyva@hotmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_restore : change schema
Date: Thu, 01 Apr 2010 16:20:01 -0400
Message-ID: <cone.1270153201.465631.18171.1000@shelca> (raw)
References: <30B673D7B5844B4394E188D9FFAEF0990160F94B@mx01.corp.castsoftware.com>
<cone.1270134403.614462.18171.1000@shelca>
<BLU102-W1C77366E9295420E963ADA11D0@phx.gbl>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: lists@stringsutils.com, jcleyva@hotmail.com
Subject: Re: pg_restore : change schema
In-Reply-To: <cone.1270153201.465631.18171.1000@shelca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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