3 ms·
I think they're specific to Oracle and SQL Server. It's a pity because they can be very useful. PostgreSQL can do it via the tablefunc extension and there's `\
by petepete 7y ago
I think they're specific to Oracle and SQL Server. It's a pity because they can be very useful.
PostgreSQL can do it via the tablefunc extension and there's `\crosstabview` which is built into psql.
https://www.postgresql.org/docs/current/tablefunc.html https://www.postgresql.org/docs/current/tablefunc.html
https://www.postgresql.org/docs/12/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW https://www.postgresql.org/docs/12/app-psql.html#APP-PSQL-ME...