I am preparing a CSV for loading onto a table using the SQL command: COPY table FROM filename WITH (FORMAT csv, HEADER) This particular table has a varchar[] (array of strings) column, and some of the items in these arrays contain special characters such as double quotes (") and backslashes (\), some of which can… Read More How to make a CSV file with arrays of varchar containing double quotes for PostgreSQL COPY

The context is that I am writing a script to send load/insert query to a postgres server to insert rows into an existent table. I read many resources about the topic, about the approach to choose, between "COPY" and multi-valued SELECT query. I want to know what is the maximum query length accepted for a… Read More What is the maximum query length accepted for a PostgreSQL multi-valued SELECT query?