David Fetter <david@fetter.org> writes:
> Although it might be nice to have different column orderings, say
> per-role, the SQL:2003 standard requires a single canonical ordering
> in the information schema. How would we handle both?
If you want some other column ordering, you make a view. The only thing
we're really lacking to make that a fully acceptable answer is
automatically-updatable views, which I believe someone is working on...
regards, tom lane