Re: Reordering columns, will this ever be simple?

I would like to make a request for this feature to be added to postgres.

Postgres is a really great database. I'm still very much a novice at using
postgres but in general, it's been a very good experience and I plan to use
it as often as I can. The community is very helpful.

My projects tend to be more seat of the pants than your average enterprise
database. Adding the ability to reorder columns in a simple manner would be
a very nice addition. I think such a feature would add to the 'curb appeal'
of postgres...make it more user friendly, more flexible.

I don't know anything about the internals of databases, how they actually
work, but from my 'ignorance is bliss' perspective, it seems odd that one
can alter field names at will in postgres but reordering columns is such a
big deal. Maybe internally columns are id'd via index position, thus order
matters, and the name is relatively light duty property? Maybe too hard to
explain it in simple terms.

Decibel! wrote:
>
> On Tue, Aug 07, 2007 at 02:28:20PM -0500, Tony Caduto wrote:
>> Gregory Stark wrote:
>> >"novnov" <novnovice(at)gmail(dot)com> writes:
>> >
>> >
>> >>Is there any plan to add such a capability to postgres?
>> >>
>> >
>> >It's been talked about. I wouldn't be surprised to see it in 8.4 but
>> >nobody's
>> >said they'll be doing it yet and there are a lot of other more exciting
>> >ideas
>> >too.
>> >
>> >
>> From a admin tool developers perspective the ability to reorder columns
>> without manually copying to a new table and all that is pretty exiting
>> :-)
>
> Patches welcome. :)
>
> BTW, this is much more likely to happen if we divorce presentation order
> from actual storage order, something that there is some desire to do
> because it would allow the engine to automagically store things in the
> optimal ordering from an alignment standpoint.
> --
> Decibel!, aka Jim Nasby decibel(at)decibel(dot)org
> EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
>
>
>

--
View this message in context: http://www.nabble.com/Reordering-columns%2C-will-this-ever-be-simple--tf4231761.html#a12129772
Sent from the PostgreSQL - general mailing list archive at Nabble.com.