2010/9/30 Ben Carbery <ben.carbery@xxxxxxxxx>: > On Thu, Sep 30, 2010 at 9:36 PM, Vincenzo Romano > <vincenzo.romano@xxxxxxxxxxx> wrote: >> >> We also have the fantastic crosstab in tablefunc module (see chapter >> F.36.1.4 for v9.0.0) >> > ..but these seem to be more pivot table functions that alter the data, > rather than displaying it differently. Not sure if this method is adaptable > but I may have a go. Alter? crosstab doesn't alter anything if you don't ask to. > To me swapping would be better suited as an option to psql. After all, > calling columns 'columns' in sql is aribtrary - they could just as easily > have been called rows or something else, so there's no reason for the output > to be fixed that way. Although that would chew a lot of memory if you have a > lot of records as you would need to read every record before formatting..and > I guess that explains why it hasn't been done. > > No idea if this can be done in other clients! Actually none, AFAIK. -- Vincenzo Romano at NotOrAnd Information Technologies Software Hardware Networking Training Support Security -- NON QVIETIS MARIBVS NAVTA PERITVS -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
