Postgresql Pivot

• As compared to the cross tab() function capabilities, we can say that the Pivot table is far more efficient.
• The Pivot table used for the data processing, and it has a lot of advantages because DB forges studio for PostgreSQL automatically calculates and generates an average of values, maximum value, minimum value, count of values and standard deviation for all the columns and rows. Which is quite beneficial for Pivot tables.
• This table below gives a list of values that are not clear and lengthy, but the Pivot table can change this into a simple form as follows.

Raw table

 

Pivot table

 

• The Pivot table is useful to give data such as averages, fill incomplete data so on.

Syntax:

SELECT student, subject FROM evaluations ORDER BY 1,2

AS final_result(Student TEXT, Geography NUMERIC,History NUMERIC,Language NUMERIC,Maths NUMERIC,Music NUMERIC)

 

• By using the above syntax, we can create a Pivot table, and it automatically updates the average of values, maximum value, minimum value, count of values and standard deviation and many more in column format as well as row format.