| From: | Ben Carbery <ben(dot)carbery(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: rotate psql output |
| Date: | 2010-09-30 11:27:48 |
| Message-ID: | AANLkTi=69AzRfHLL=poMX0pkvOU81_VtVBd=Phr1f5wB@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Sep 30, 2010 at 9:19 PM, Tommy Gildseth
<tommy(dot)gildseth(at)usit(dot)uio(dot)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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vincenzo Romano | 2010-09-30 11:31:40 | Re: rotate psql output |
| Previous Message | Devrim GÜNDÜZ | 2010-09-30 11:21:31 | Re: rotate psql output |