Re: full featured alter table?

Sven Köhler <skoehler@upb.de>

From: Sven Köhler <skoehler@upb.de>
To: pgsql-general@postgresql.org
Date: 2003-06-14T17:45:23Z
Lists: 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.