Re: rotate psql output

On 30/09/2010 12:17, Ben Carbery wrote:
> I have a query that returns many columns but few rows. I would like to
> display output horizontally instead of vertically, i.e. rotating by 90
> degress, so column headings appear in the left margin, and the output is
> not 'wrapped'.
> Is this possible? I have had no luck searching for this as rotate
> usually means log rotation.

Googling on "sql swap rows columns" found this:

http://stackoverflow.com/questions/584232/t-sql-how-to-swap-rows-and-columns

...which you'll be able to adapt.

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie