postgres sql view with a col for each identifier
<p>I have a table for observations, with a "time", "value" and "identifier" column. The time col holds the time stamp of the values, the identifier holds the parameter names. How can I create a view with a separate col for each parameter and a row for each time stamp. There will be empty grids, because not all parameters are measured each time..
Thanks in advanced</p>