Search Postgresql Archives

Re: rotate psql output

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Thu, Sep 30, 2010 at 9:19 PM, Tommy Gildseth <tommy.gildseth@xxxxxxxxxxx> 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!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux