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
regards, tom lane
In response to
pgsql-general by date
|Next:||From: Max||Date: 2004-11-30 16:12:06|
|Subject: Re: [ANNOUNCE] USENET vs Mailing Lists Poll ...|
|Previous:||From: Pierre-Frédéric Caillaud||Date: 2004-11-30 16:02:19|
|Subject: Re: VACUUM and ANALYZE Follow-Up |