As suggested by David I would use Tablefunc.
This query should work.
select * from crosstab (
'select timestamp, name, value from originaltable',
'select distinct name from originaltable order by name'
)
as transposedtable (timestamp varchar, name1 varchar, name2 varchar, name3
varchar)
Rega
On Tue, Aug 17, 2021 at 11:29 AM Edu Gargiulo wrote:
>
> I need to transpose and return one row for a single timestamp and one
> column for every name (fixed number of names), something like this
>
>
https://www.postgresql.org/docs/current/tablefunc.html
or
select ..., max(value) filter (where
Hi all,
I got a view that returns values in the following format
timestamp | name |value
-
ts1name1 value11
ts1name2 value12
ts1name3 value13
ts2name1 value21
ts2name2