ts-sql-query icon indicating copy to clipboard operation
ts-sql-query copied to clipboard

Published 20 hours ago • verified publisher icon juanluispaz

Bulk inserts using unnest

Open DGCarramona opened this issue 1 year ago • 2 comments

Hello, Given PostgreSQL has a limit of 65535 params in prepared queries, do you have any plans to implement something like described in this blog post ? https://klotzandrew.com/blog/postgres-passing-65535-parameter-limit

DGCarramona avatar Mar 04 '24 08:03 DGCarramona

Hi!

I'm preparing version 2 of ts-SQL-query, and I want to address this kind of thing.

This point had been on my list for changes in the generated SQL.

Can you share any other related information, including for other databases? that will be useful.

juanluispaz avatar Mar 04 '24 12:03 juanluispaz

Sorry, I work only with PostgreSQL, so I will not be able to provide information for other databases. But if you have any question regarding this subject, I would be glad to provide all the help I can.

DGCarramona avatar Mar 04 '24 13:03 DGCarramona