Tony Caduto <tony(dot)caduto(at)amsoftwaredesign(dot)com> 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