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@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
