suacode

romansklenar / crosstab.sql

Last active February 1, 2023 18:46

PostgreSQL "pivot table" example using tablefunc extension

	CREATE EXTENSION tablefunc;

	CREATE TABLE sales(year int, month int, qty int);
	INSERT INTO sales VALUES(2007, 1, 1000);
	INSERT INTO sales VALUES(2007, 2, 1500);
	INSERT INTO sales VALUES(2007, 7, 500);
	INSERT INTO sales VALUES(2007, 11, 1500);
	INSERT INTO sales VALUES(2007, 12, 2000);
	INSERT INTO sales VALUES(2008, 1, 1000);
	INSERT INTO sales VALUES(2009, 5, 2500);