Re: Renaming tables to other schemas

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: ziga(at)ljudmila(dot)org, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Subject: Re: Renaming tables to other schemas
Date: 2004-02-15 12:53:50
Message-ID: 1076849630.10896.123.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, 2004-02-15 at 01:34, Neil Conway wrote:
> ziga(at)ljudmila(dot)org writes:
> > The capability to move objects to other schemas would be quite
> > useful.
>
> I agree. It's not utterly-trivial to implement (for one thing, you
> need to move any dependant objects like indexes to the new schema),
> but some form of this functionality would be a useful thing to add,
> IMHO.

It's not that hard to do either (I've done about 100 tables by hand at
this point).

Anyway, this should be supported by all RENAME commands, not just ALTER
TABLE.
--
Rod Taylor <rbt [at] rbt [dot] ca>

Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
PGP Key: http://www.rbt.ca/rbtpub.asc

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Florian Weimer 2004-02-15 13:05:16 Re: [pgsql-hackers-win32] Sync vs. fsync during checkpoint
Previous Message Manfred Spraul 2004-02-15 11:36:16 Re: friday 13 bug?