One of the few problems I have with postgres is that one is stuck with
columns ordered by time of creation, unless one resorts to dropping the
table and rebuilding from ddl. If you have data and a bunch of contraints,
it's not simple. It's not a critical capability either, but reordering
columns in the other databases I work with is very simple. Schemas do evolve
and I like to keep things in order, naturally.
Is there any plan to add such a capability to postgres? Is there deep seated
reason why reordering columns can't be handled without doing a root canal on
the database?
If there already is some simple way to reorder columns, please let me know.
--
View this message in context:
http://www.nabble.com/Reordering-columns%2C-will-this-ever-be-simple--tf4231761.html#a12039408
Sent from the PostgreSQL - general mailing list archive at Nabble.com.