Re: Rename Schema or Script DDL only a schema

From: "Olivier Hubaut" <olivier(at)scmbb(dot)ulb(dot)ac(dot)be>
To: kumar <sgnerd(at)yahoo(dot)com(dot)sg>, pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Rename Schema or Script DDL only a schema
Date: 2004-04-06 08:17:49
Message-ID: opr502rzcr94ope3@olivier.amaze.ulb.ac.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, 6 Apr 2004 14:32:04 +0530, kumar <sgnerd(at)yahoo(dot)com(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message kumar 2004-04-06 09:02:04 Rename Schema or Script DDL only a schema
Previous Message scott.marlowe 2004-04-05 22:55:45 Re: DB question - Merging data from one table to another.