PostgreSQL 9.6: Introduced CROSSTABVIEW (pivot) in PSQL

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

In this post, I am sharing a new feature CROSSTABVIEW in PSQL of PostgreSQL 9.6. Many times we require data arrangement horizontally, instead of vertically.

Something like we are doing in a spreadsheet where one element has a multiple child elements and require calculation horizontally for each group of items.

Now, you can use CROSSTABVIEW in new PSQL for this kind of requirement.

Below is a small demonstration of this:

Open a psql command line and create a below sample table:

Execute below few SELECTs:

Now check sample SELECT with CROSSTABVIEW:

The result: