Tom Lane wrote:
Richard Huxton <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
