CODEWITHSUNDEEP
sqlwindowspostgresql
VASHIA
VASHIA

Reputation: 26

Postgres 10 ERROR: target lists can have at most 1664 entries

I'm using postgres10 on Windows. In my query,that I copy the result to CSV, I want to have 1700 columns but I got this error:

"ERROR: target lists can have at most 1664 entries SQL state: 54000"

Any one have an idea of how to fix it?

Upvotes: 0

Views: 5124

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 246848

This limit cannot be extended, and rightly so.

I recommend that you create a temporary table for these values and join with it. That has the additional advantage that you can ANALYZE the table for better estimates.

Upvotes: 1

Related Questions