Horton

Re: Renaming tables to other schemas

Rod Taylor <rbt@rbt.ca>

View thread View on postgr.es
From: Rod Taylor <rbt@rbt.ca>
To: Neil Conway <neilc@samurai.com>
Cc: ziga@ljudmila.org, PostgreSQL Development <pgsql-hackers@postgresql.org>, Bruce Momjian <pgman@candle.pha.pa.us>
Date: 2004-02-15T12:53:50Z
Lists: pgsql-hackers 
On Sun, 2004-02-15 at 01:34, Neil Conway wrote:
> ziga@ljudmila.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