Re: RES: Add column and specify the column position in

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.