Make rows to Columns in Postgresql

Asked Aug 09 '19 at 08:46

Active Aug 09 '19 at 08:46

Viewed 80 times

I would like to change below data set to

with data as (select * from (values
             ('2018-08-09'::date,'cancel',35),
             ('2018-08-09'::date,'sum',25),
             ('2018-08-09'::date,'count',10)
             ) as v(date,row,number))

to this make rows to columns

        date           cancel      sum     count
        2018-08-09      35          25      10

How can I do that? Please help.

Thank you.

asked Aug 09 '19 at 08:46

melik

1,268
3
21
42

Please Google for "SQL pivot query" – Tim Biegeleisen Aug 09 '19 at 08:51
https://www.postgresql.org/docs/9.1/tablefunc.html -> crosstab – jbet Aug 09 '19 at 08:59

Make rows to Columns in Postgresql

0 Answers0