Re: RES: Add column and specify the column position in - Mailing list pgsql-general

From Bricklen Anderson
Subject Re: RES: Add column and specify the column position in
Date
Msg-id 446C9AA0.5000506@presinet.com
Whole thread Raw
In response to Re: RES: Add column and specify the column position in  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Emi Lu
Date:
Subject: Re: RES: Add column and specify the column position in
Next
From: Bob Pawley
Date:
Subject: Re: Interface