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.