Alter column position - Mailing list pgsql-general

From Patrick Rutkowski
Subject Alter column position
Date
Msg-id 0CBAF959-190F-40C3-A658-43B5D9E68412@gmail.com
Whole thread Raw
Responses Re: Alter column position  (David Fetter <david@fetter.org>)
List pgsql-general
I'm curious, is there any latest word on this?

(Note that I've read fully the link http://wiki.postgresql.org/wiki/Alter_column_position as well as all links stemming
fromit). 

I could go digging through the latest source code, or the mailing list Archives, but I get the feeling I'll really only
getthe latest info by asking here. 

Yesterday I forgot to put an auto-incremting "id" column for the usual pkey on a table I was creating (I was just
reallysleepy). So I did an ALTER TABLE and added to the end. But then seeing the "id" column at the end of the column
listin psql and PgAdminIII just really messed with the aesthetic sensibilities in my brain. 

I know, I can do the work-arounds in the wiki, and in this case I just re-created the table since it was fresh and had
nodata, but I would still really love to be able to properly re-order things. 

I would love to do it myself, but I'm barely even proficient with writing front-end SQL, let alone working on the
backendof a complicated server implementation. 

Dunno what good this email will do,
just felt like writing a bit :-)
-Patrick


pgsql-general by date:

Previous
From: Deepa Thulasidasan
Date:
Subject: Help reqd on azimuth finction
Next
From: David Fetter
Date:
Subject: Re: Alter column position