Re: logical column ordering

Jim Nasby wrote:
> On 2/27/15 2:49 PM, Alvaro Herrera wrote:
> >Tomas Vondra wrote:
> >
> >>1) change the order of columns in "SELECT *"
> >>
> >>    - display columns so that related ones grouped together
> >>      (irrespectedly whether they were added later, etc.)
> 
> FWIW, I find the ordering more important for things like \d than SELECT *.

Logical column ordering is (or should be) used in all places where
column lists are expanded user-visibly.  \d would be one of those.
Think column order in the output of a JOIN also, for instance -- they
must follow logical column order.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services