On Tue, 7 Aug 2007 11:07:39 -0700 (PDT) novnov <novnovice@xxxxxxxxx> wrote: <snip> > 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? Probably because the theory behind the relational model (at least as far as I understand it) is that column and row ordering is irrelevant. >From http://en.wikipedia.org/wiki/Relational_model : "The relational model requires there to be no significance to any ordering of the attributes of a relation." Just like if you do a SELECT * that the order of the rows returned could change at any time unless you specify an ORDER BY clause. That said, most people I imagine like being able to "re-order" the columns that a SELECT * produces. > If there already is some simple way to reorder columns, please let > me know. CREATE VIEW my_favorite_order AS SELECT col2, col1, col5, col4, etc FROM base_table; SELECT * FROM my_favorite_order; Only drawback is that you have to re-build the view if the column names in the base table change. Josh ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
