PostgreSQL: Example of CROSSTAB query, for PIVOT arrangement

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

In this post, I am sharing an example of CROSSTAB query of PostgreSQL. The “tablefunc” module provides the CROSSTAB() which uses for displaying data from rows to columns.

I already shared few similar articles on PostgreSQL PIVOT and new CROSSTABVIEW.

PostgreSQL: CREATE PIVOT TABLE to arrange Rows into Columns form

PostgreSQL 9.6: Introduced CROSSTABVIEW (pivot) in PSQL

Please check the below demonstration:

Create a required extension:

Create sample table with data:

Use CROSSTAB for displaying data from rows to columns:

Result: