> \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