> > > \x doesn't exactly rotate it either. \x puts the column headers down > the side instead of across the top, but it doesn't put the rows across > the top instead of down the side. Rather, each row is listed in a > separate chunk.
true, it is rotation per one row. I was wrong. > This feature is doing something else again. I've > actually never seen this particular transformation anywhere except for > Microsoft Excel's pivot tables, which I still find confusing. > > > -- > Robert Haas > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company >
