Re: rotate psql output

From: Tommy Gildseth <tommy(dot)gildseth(at)usit(dot)uio(dot)no>
To: Ben Carbery <ben(dot)carbery(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: rotate psql output
Date: 2010-09-30 11:19:51
Message-ID: 4CA47257.7040305@usit.uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
DBA, Gruppe for databasedrift
Universitetet i Oslo, USIT
m: +47 45 86 38 50
t: +47 22 85 29 39

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2010-09-30 11:21:31 Re: rotate psql output
Previous Message Ben Carbery 2010-09-30 11:17:24 rotate psql output