Re: rotate psql output

From: Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>
To: rod(at)iol(dot)ie
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 11:36:55
Message-ID: AANLkTi=-wp8vWfB-A0pqtUv81avKaiznndWFW4faeD_G@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2010/9/30 Raymond O'Donnell <rod(at)iol(dot)ie>:
> On 30/09/2010 12:17, Ben Carbery wrote:
> Googling on "sql swap rows columns" found this:
>
> http://stackoverflow.com/questions/584232/t-sql-how-to-swap-rows-and-columns
>
> ...which you'll be able to adapt.

We also have the fantastic crosstab in tablefunc module (see chapter
F.36.1.4 for v9.0.0)

--
Vincenzo Romano at NotOrAnd Information Technologies
Software Hardware Networking Training Support Security
--
NON QVIETIS MARIBVS NAVTA PERITVS

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben Carbery 2010-09-30 11:46:14 Re: rotate psql output
Previous Message Raymond O'Donnell 2010-09-30 11:33:38 Re: rotate psql output