I need to use pivot in postgres, below is the base table
Below is the desired output
Please help me with the query.
-
meta.stackoverflow.com/questions/285551/…user330315– user3303152016-03-04 13:46:45 +00:00Commented Mar 4, 2016 at 13:46
Add a comment
|
2 Answers
This is actually an un-pivot, not pivot
select year, week, 'loading' as area, loading as value
from the_table
union all
select year, week, 'picking', picking
from the_table
union all
select year, week, 'painting', painting
from the_table
1 Comment
Anshul
Thank you so much.. saved me
If you have only 3 columns which you need to pivot, then use union
select year,week,'loading' as aread,loading as val from tbl
union all
select year,week,'painting' as area,painting as val from tbl
union all
select year,week,'picking' as area,picking as val from tbl
If the number of column is dynamic, then I 'd suggest you to use dynamic pivot.
Dynamic pivot query using PostgreSQL 9.3
http://www.cureffi.org/2013/03/19/automatically-creating-pivot-table-column-names-in-postgresql/
