Vertabelo Blog

Learn how to design and use database models
Master Python Online! This interactie online course is dedicated (but not limited) to data science beginners and business professionals performing data analysis with CSV files. Enroll In Other Python courses:
Maria Alcaraz 19th May 2016

reportSome 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.