Re: rotate psql output

Поиск
Список
Период
Сортировка
От Ben Carbery
Тема Re: rotate psql output
Дата
Msg-id AANLkTi=69AzRfHLL=poMX0pkvOU81_VtVBd=Phr1f5wB@mail.gmail.com
обсуждение исходный текст
Ответ на Re: rotate psql output  (Tommy Gildseth <tommy.gildseth@usit.uio.no>)
Ответы Re: rotate psql output  (Vincenzo Romano <vincenzo.romano@notorand.it>)
Список 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 по дате отправления:

Предыдущее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: rotate psql output
Следующее
От: Vincenzo Romano
Дата:
Сообщение: Re: rotate psql output