Postgresql Pivot Without Crosstab

No, you cannot create a Pivot table in PostgreSQL without using crosstab function as you have to use a tablefunc module for a required database.

• Pivot is the modified, detailed and straightforward data table of crosstab table.
• By taking random data or raw data, you can modify it to the crosstab table directly by using the crosstab function afterwards. You can convert it to Pivot table using Pivot function.  
• Pivot and crosstab are similar to each other, but Pivot generated without writing a function.
• As Pivot is used to organise, sort, group, sum or average data stored and this da give data relations except that it is similar to crosstab table.

Raw data using crosstab() function before Pivoting:

After Pivoting table: