Re: rotate psql output - Mailing list pgsql-general

From Ben Carbery
Subject Re: rotate psql output
Date
Msg-id AANLkTi=69AzRfHLL=poMX0pkvOU81_VtVBd=Phr1f5wB@mail.gmail.com
Whole thread Raw
In response to Re: rotate psql output  (Tommy Gildseth <tommy.gildseth@usit.uio.no>)
Responses Re: rotate psql output  (Vincenzo Romano <vincenzo.romano@notorand.it>)
List pgsql-general


On Thu, Sep 30, 2010 at 9:19 PM, Tommy Gildseth <tommy.gildseth@usit.uio.no> wrote:
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.
BC


Have you tried \x ?

--
Tommy Gildseth


Hadn't tried that. Actually it's much better, but each record is displayed separately, so visually comparing 2 or 3 records is not possible.

Strange if this can't be done, I would have thought it a common request!

pgsql-general by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: rotate psql output
Next
From: Vincenzo Romano
Date:
Subject: Re: rotate psql output