Re: How to transform table rows into Colum?

you can also generate a crosstab table using the sign function

you can check out the link below ( its a sqlite tutorial, but the same idea will work for pg too )

http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html


On 03/09/2011 12:16 PM, Eric Ndengang wrote:

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