Jwexler,
Please suggest how best to propose that the following feature be added to
PostgreSQL's roadmap?
Ability to "Alter column position" as described in the section "Adding alter column
syntax into postgres" of http://wiki.postgresql.org/wiki/Alter_column_position (and the two
links in that section).
Fortunately, there's already a specification discussed for this. We'd
like to have the ability for each column to have both a logical position
and a physical position which are separate. This would also allow us to
dynamically re-arrange the columns at CREATE time for best storage
efficiency.
It would also provide a foundation for column aliases.
However, I don't think there's much code for this yet. Are you in a
position to either write code, or fund work?
Once implemented in tables, I would suggest a command perhaps similar to that
in mysql
(http://trebleclick.blogspot.com/2009/02/reorder-mysql-table-columns.html) as
well as adding the feature to pgadmin and to PostgreSQL views.
Hmmmm. It *might* be worth supporting that for MySQL compatibility, but
really it hardly seems adequate to a large table where you want to
rearrange most of the columns. Seems like we'd need a better syntax.
I would suggest that addition of this feature should be considered common sense.
Actually, it's not. Column ordering is supposed to be arbitrary and
implementation-dependent, so we're on our own here. However, it would
help people administer their applications ... even if it encourages bad
application writers to continue using "SELECT *".
--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
