Postgres Pro
Downloads
Home   >   mailing lists

How to transform table rows into Colum? - Mailing list pgsql-sql

From Eric Ndengang
Subject How to transform table rows into Colum?
Date
Msg-id 4D77B5FC.6010502@affinitas.de
Whole thread Raw
Responses Re: How to transform table rows into Colum?  (Dmitriy Igrishin <dmitigr@gmail.com>)
Re: How to transform table rows into Colum?  (Richard Albright <ralbright@insiderscore.com>)
List pgsql-sql
Tree view 
Hi Guys,
I have the following table:

Name   Value   rang  salary
------------------------------------
name1   value1  1    2500
name2   value2  2    2600
name3   value 3 3    300

and want to obtain the following result:

name1  name2  name3
------------------------------------
value1  value2   value3
1             2            3
2500      2600    300

what should i do ? I read about the crosstab function  in postgresql but 
still have no idea on how to use it to solve this problem.
Any help would be appreciated
Regards

-- 
Eric Ndengang
Datenbankadministrator

Affinitas GmbH  |  Kohlfurter Straße 41/43  |  10999 Berlin  |  Germany
email: eric.ndengang_foyet@affinitas.de  | tel: +49.(0)30. 991 949 5 0  |  www.edarling.de

Geschäftsführer: Lukas Brosseder, David Khalil, Kai Rieke, Christian Vollmann
Eingetragen beim Amtsgericht Berlin, HRB 115958

pgsql-sql by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: A function to count all ocurrences of a character within a string.
Next
From: Dmitriy Igrishin
Date:
Subject: Re: How to transform table rows into Colum?