Rod Taylor wrote: -- Start of PGP signed section. > On Sun, 2004-02-15 at 01:34, Neil Conway wrote: > > [EMAIL PROTECTED] 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.
Added TODO: o Allow the schema of objects to be changed -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html