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

From Sven Köhler
Subject Re: full featured alter table?
Date
Msg-id bcfmsm$e43$1@main.gmane.org
Whole thread Raw
In response to Re: full featured alter table?  (merlyn@stonehenge.com (Randal L. Schwartz))
List pgsql-general
> 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.

I think we don't want to reorder our column to make "select *" have a
order that fits our needs.

as i said in my other posts, we only want it for our selves to have a
defined order, that doesn't look that much chaotic.


pgsql-general by date:

Previous
From: Sven Köhler
Date:
Subject: Re: full featured alter table?
Next
From: Bruno Wolff III
Date:
Subject: Re: full featured alter table?