Is there any way to transpose rows to columns in Knex.js?

Asked Jun 26 '19 at 23:55

Active Jun 27 '19 at 00:01

Viewed 232 times

Currently is there any way to transpose rows to columns like crosstab() in PostgreSQL?

I didn't see anything in the documentation at https://knexjs.org that would do exactly this but maybe there is some group of functions that could achieve this result.

Current result: 1

Desired transposed result: 2

edited Jun 27 '19 at 00:01

asked Jun 26 '19 at 23:55

mathro

If you add SQL query which you are trying to create I can help. – Mikael Lepistö Jun 29 '19 at 15:01
1

Possible duplicate of [PostgreSQL Crosstab Query](https://stackoverflow.com/questions/3002499/postgresql-crosstab-query) – Mikael Lepistö Jul 01 '19 at 08:01

Is there any way to transpose rows to columns in Knex.js?

0 Answers0