> Really?
>
> What if two PgAdmin sessions want two different order?
> Presentation order should be done at the application level.
*sigh* ...
The order of columns, the column type etc. is all part of table
definition. if two guys want different column-orders this is just not
possible - but if both have the possibility to agree and define one
column ordering is better than force them to use what every postgresql
decides (in most cases it is the chronological order, in which the
columns have been created).
and yes - column order of a select should be defined at application
level - especially if the application uses indexes to access the columns
- but some APIs offer access to the columns by using their name.