From: Olivier Hubaut <olivier@scmbb.ulb.ac.be>
To: kumar <sgnerd@yahoo.com.sg>
To: pgsql <pgsql-sql@postgresql.org>
Subject: Re: Rename Schema or Script DDL only a schema
Date: Tue, 06 Apr 2004 11:17:49 +0300
Message-ID: <opr502rzcr94ope3@olivier.amaze.ulb.ac.be> (raw)
In-Reply-To: <01ec01c41bb5$deccc9d0$7502a8c0@hdsc.com>
References: <01ec01c41bb5$deccc9d0$7502a8c0@hdsc.com>
On Tue, 6 Apr 2004 14:32:04 +0530, kumar <sgnerd@yahoo.com.sg> wrote:
> Dear Friends,
>
> Postgres 7.3.2 on Linux 8.
>
> I wanna move about 100 tables from one schema to another (within a
> database). Is possible to do that? Seems pg_dump doesnt have an option
> to script only the schema.
>
> Else, it possible to rename the schema.
>
> Please shed some light.
>
> Thanks
> Kumar
Not with this version of PG.
v7.4 allows you to rename schema and dump specific schemas.
--
Downloading signature ... 99%
*CRC FAILED*
signature aborted
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-sql@postgresql.org
Cc: olivier@scmbb.ulb.ac.be, sgnerd@yahoo.com.sg
Subject: Re: Rename Schema or Script DDL only a schema
In-Reply-To: <opr502rzcr94ope3@olivier.amaze.ulb.ac.be>
* 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