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

Reply via email to