21
I have a view which looks like this
value1count value2count value3count
----------------------------------------
25 35 55
I need to transpose the column header into rows and so I need it to look like
Values Count
-----------------------------
value1count 25
value2count 35
value3count 55
I can do this by selecting individual column names as first column and data as second column and then do a union of the same for all columns.
Is there a better way to do this? I am using PosgreSQL 8.1 and so don't have pivot operators to work with.
Thanks for your response in advance.