'Is it possible in Postgresql to use one column as source of names of columns?

Suppose that we have table with field ID, type, Date, any_value

Suppose we have such values in a table (select * from my_table):

ID     type     date          any_value
1      alfa     2022-01-01    50
2      beta     2022-01-01    70
3      alfa     2022-01-02    111
4      beta     2022-01-02    444
...

Is it possible to create a query with a such result (if it is - how I may do it?):

date          alfa        beta      
2022-01-01   50          70
2022-01-02   111         444
....

Of course it should be performed automatically, not by making the simplest "left join" for each column (as the number of values in "type" column may be different in May , different in July- and it should be only one query.

(if it would be "gamma" in "type" column, then it should be "gamma" column after beta column, if "delta" - then "delta")

postgresqlsqlfunctionaverage


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions