Hi !
I am trying to use crosstab function from tablefunc.
SELECT * from crosstab('select date, source, name, value FROM cth ORDER by
1', 'select distinct name from cth order by 1') AS ct(date timestamp,
source text, val1 text, val2 text, val3 text, val4 text, val5 text);
The content of the table that I get is fine. However, I would like to get
appropriate names instead of arbitrary 'val1', 'val2', ...
Is it possible to rename the table columns with the result of 'select
distinct name from cth order by 1' ?
Thanks.