Re: full featured alter table?

On Fri, Jun 13, 2003 at 06:49:01PM -0400, Tom Lane wrote:
> What would make more sense to me than a tightly-wrapped-up ALTER command
> at the SQL level is some sort of interactive conversion wizard, perhaps
> as part of phppgadmin or Red Hat's graphical tool suite. It could walk
> you through all these considerations, get your okay on each nontrivial
> semantic change, and then apply all the operations within a single
> transaction. AFAIK we have all the ALTER functionality needed to
> support such a tool.

The one thing we don't have that I think would be useful is a way to
re-order the columns in a table. Maybe it's just me, but I tend to want
column to appear in a specific order, and the only way you can
accomplish this today is by re-creating the entire table.
--
Jim C. Nasby (aka Decibel!) jim(at)nasby(dot)net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"