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) […]
I'm Anvesh Patel, a Database Engineer certified by Oracle and IBM. I'm working as a Database Architect, Database Optimizer, Database Administrator, Database Developer. Providing the best articles and solutions for different problems in the best manner through my blogs is my passion. I have more than six years of experience with various RDBMS products like MSSQL Server, PostgreSQL, MySQL, Greenplum and currently learning and doing research on BIGData and NoSQL technology. -- Hyderabad, India.