Postgresql Crosstab() Function - Two Ways of Creating Pivot Tables in PostgreSQL

Опубликовано: 02 Февраль 2022
на канале: Devart
9,451
32

A Pivot Table is an effective technique/tool for calculating, compiling, and analyzing data, bound to simplify the search for patterns and trends.
Pivot Tables can help you aggregate, sort, organize, reorganize, group, sum, or calculate the average of a dataset stored in a database in order to understand data relations and dependencies in the best possible way.
In this video, we'll try to compare two ways of creating a pivot table in Postgresql:
one using the crosstab function in PostgreSQL, which allows transposing rows to columns;
and another - with the help of the dbForge Studio for PostgreSQL tool.
The Pivot Table functionality built into dbForge Studio provides interactive data visualization that is vastly superior to the crosstab() capabilities in PostgreSQL.
To look at the data from a completely different angle, the user needs just a few clicks.

⭐️Timestamps:
00:00 Introduction
00:05 Pivot Table Explained
00:27 Comparing two ways of creating a pivot table
00:42 Postgresql crosstab function
00:50 Сreating Pivot Tables with dbForge Studio
01:30 Grand Total columns
01:46 Change the background of the Pivot Table cell, the font color
02:05 Visualize pivot data as a chart
02:23 Group, sort, and filter the data in the Pivot Table
02:46 Wrapping up

⭐️Thank you for watching!

🔥 Download a free 30 days trial of dbForge Studio for PostgreSQL and start creating Pivot Tables effortlessly!
https://www.devart.com/dbforge/postgr...

👉🏽Check out more information about Pivot Table functionality:
https://www.devart.com/dbforge/postgr...

👉🏽Read our article about creating a pivot table in PostgreSQL:
https://blog.devart.com/pivot-tables-...

🔔 Subscribe to the Devart Youtube channel:
   / devartsoftware  

#PostgreSQL #PivotTable #dbForge #Devart #SQLDatabase #PostgreSQLTutorial #PostgreSQLTools


Смотрите видео Postgresql Crosstab() Function - Two Ways of Creating Pivot Tables in PostgreSQL онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Devart 02 Февраль 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 9,451 раз и оно понравилось 32 людям.