Tag: postgresql-copy

What is the maximum query length accepted for a PostgreSQL multi-valued SELECT query?

bulkinsert insert postgresql postgresql-copy sql

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 PostgreSQL multi-valued SELECT query ?

Use COPY to read a csv into database, while adding constant columns

csv postgresql postgresql-copy sql

I have a series of CSV files, in the format: “Alice”,”Bob”,”A”,123.46,”4″ “Charlie”,”Dana”,”B”,987.6543,”9″ … I want to produce a table like this: id file_id mch c1 c2 c3 c4 …