Pivot in Postgres

Question

I need to convert following rows:

table {name,col} values{(x,value1), (x , value2) (x , value3) (x , value2) (x , value3) (y , value1) (y , value3) (y , value3) (z , value1)}

into following columns: {name ,value1, value2 , value3} values{(x,1,2, 2), (y, 1, 0 , 2)(z, 1, 0 , 0)} I use the following code but it doesn't know crosstab:

SELECT * FROM crosstab ( 'SELECT name , col, count(col) FROM table GROUP BY name order by name ) AS (name text, value1 integer, value2 integer, value3 integer)

Possible duplicate of PostgreSQL Crosstab Query

Nick
– Nick

2017-06-23 22:40:22 +00:00
Commented Jun 23, 2017 at 22:40 — Nick
– Nick, Commented Jun 23, 2017 at 22:40

Ms workaholic · Accepted Answer · 2017-06-23 23:32:57Z

1

This line should be added before the code: CREATE EXTENSION IF NOT EXISTS tablefunc;

answered Jun 23, 2017 at 23:32

Ms workaholic

4032 gold badges10 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Pivot in Postgres

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related