Re: change natural column order

Tom Lane wrote:

>Richard Huxton <dev(at)archonet(dot)com> writes:
>
>
>>I think you'll find you're out of luck. IIRC there was some discussion
>>on the hackers list regarding a mapping layer that would let you
>>re-order columns. I think the decision was "too much work for too small
>>a gain".
>>
>>
>
>Yup, that was exactly the conclusion. Too much work and too much risk
>of introducing bugs (by using the wrong one of logical and physical
>column number in any given place).
>
>You really have to drop and recreate the table if you want to reorder
>the columns.
>
>
This can be hard if you have foreign keys. I used dump, edit, and
restore the whole database in the past.

Mage