KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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.
Tags (comma-separated)
Save Edits
Cancel