New SQL Course!
Learn the basics of T-SQL for SQL Server, retrieve data from an SQL Server database and build simple reports.
View course
Discover our other courses:
Some years ago, when PostgreSQL version 8.3 was released, a new extension called tablefunc was introduced. This extension provides a really interesting set of functions. One of them is the crosstab function, which is used for pivot table creation. That’s what we’ll cover in this article.