Re: full featured alter table? - Mailing list pgsql-general

From merlyn@stonehenge.com (Randal L. Schwartz)
Subject Re: full featured alter table?
Date
Msg-id 86y90436zu.fsf@red.stonehenge.com
Whole thread Raw
In response to Re: full featured alter table?  ("Jim C. Nasby" <jim@nasby.net>)
Responses Re: full featured alter table?  (Sven Köhler <skoehler@upb.de>)
List pgsql-general
>>>>> "Jim" == Jim C Nasby <jim@nasby.net> writes:

Jim> The one thing we don't have that I think would be useful is a way to
Jim> re-order the columns in a table. Maybe it's just me, but I tend to want
Jim> column to appear in a specific order, and the only way you can
Jim> accomplish this today is by re-creating the entire table.

Column order shouldn't matter.  It matters only when you say "SELECT *",
and the best literature out there warns against the foibles of such.

--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn@stonehenge.com> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Index not being used in MAX function (7.2.3)
Next
From: Sven Köhler
Date:
Subject: Re: full featured alter table?