Tony Caduto <tony.caduto@xxxxxxxxxxxxxxxxxxxx> writes: >> It would definately be nice if the end-user concept of column order >> wasn't tied to the physical order in the database. > Ok this may be over simplistic, but we have a attnum for the physical > order, why not just add a attorder and then we could just change that > numbering and order by that field instead of attnum? Please go back and read the very extensive discussions of this question a couple years ago in the pghackers archives (around the time we were implementing DROP COLUMN, iirc). There is no "just" about it. regards, tom lane
