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 … Continue reading PostgreSQL 9.6: Introduced CROSSTABVIEW (pivot) in PSQL