Re: rotate psql output

From: Matthew Seaman <m(dot)seaman(at)infracaninophile(dot)co(dot)uk>
To: Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>
Cc: Ben Carbery <ben(dot)carbery(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: rotate psql output
Date: 2010-09-30 12:11:30
Message-ID: 4CA47E72.6070100@infracaninophile.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 30/09/2010 12:31, Vincenzo Romano wrote:
> 2010/9/30 Ben Carbery <ben(dot)carbery(at)gmail(dot)com>:
>> Strange if this can't be done, I would have thought it a common request!
>
> Just curiosity. Is there any other DB capable of such a thing?
>

MySQL does this using an alternate end-of-statement character:

';' or '\g' gives the usual orientation,

'\G' gives the rotated orientation.

Cheers,

Matthew

--
Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard
Flat 3
PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate
JID: matthew(at)infracaninophile(dot)co(dot)uk Kent, CT11 9PW

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michele Petrazzo - Unipex 2010-09-30 12:33:47 [9.0] hot standby plus streaming replication questions
Previous Message Vincenzo Romano 2010-09-30 11:49:22 Re: rotate psql output