Alter column position

From: Patrick Rutkowski <rutski89(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Alter column position
Date: 2010-05-22 13:34:50
Message-ID: 0CBAF959-190F-40C3-A658-43B5D9E68412@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 from it).

I could go digging through the latest source code, or the mailing list Archives, but I get the feeling I'll really only get the 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 really sleepy). So I did an ALTER TABLE and added to the end. But then seeing the "id" column at the end of the column list in 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 no data, 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 backend of a complicated server implementation.

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2010-05-22 14:49:28 Re: Alter column position
Previous Message Deepa Thulasidasan 2010-05-22 12:02:27 Help reqd on azimuth finction