Emi Lu wrote:
No. It is not for select.
I have tens of tables with very clean structure. For example, username,
application_code, last_modified_by, etc in specific orders.
Since the business model is changed, I have to add some columns to
serveral tables.
I prefer columns orders following my other tables.
In any case, there's extensive discussion about this in the -hackers
archives. IIRC, there is consensus that this would be nice to have but
no one has cared enough to actually make it happen. There are some
non-trivial issues since this would mean either completely re-writing
the table when you do an ALTER or you'd have to be able to divorce the
catalog representation of a table with the on-disk representation.
Though there are other advantages to doing the later, it's non-trivial.
If it does not support, I will recreate my tables.
Thanks.
Have you considered creating a view over the tables in question? You can
order the attributes in any fashion you like that way.
