Re: transpose time-series columnar data

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Tue, Aug 17, 2021 at 11:29 AM Edu Gargiulo <egargiulo@xxxxxxxxx> 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 name = 'name1') as name1, max(value) filter (where name = 'name2') as name2, etc from tbl group by ...

David J.