Collected from the PG bugs email list.
|Reported by||Vivek Kamath|
Body of first available message related to this bug follows.
The following bug has been logged on the website: Bug reference: 16424 Logged by: Vivek Kamath Email address: (redacted) PostgreSQL version: 10.6 Operating system: Linux Unix Description: Hi, I am copying a csv file where the fields are quoted with " and separated by ,. I am using below syntax to copy data using below syntax psql -c "COPY table_name from filename WITH (FORMAT csv)". On Analysis I observed that any data that even number of double quotes in it are copied successfully but fails when it has odd number of double quotes in it. For ex 1234,"Test "hi" ","Test bye" will be loaded as 1234,Test hi, Test bye in table successfully but my expectation is to load data as 1234,Test "hi", Test bye where as 1234,"Test "hi ", "Test bye" will fail with error ERROR: unterminated CSV quoted field.. In this case my expectation is to load data as 1234,Test "hi, Test bye. Also since all this is is happening as part of the batch. I cannot pre-process the data as the same data set needs to be loaded in Redshift DB. Copy command works perfectly fine with this data set in redshift. Idea is load whatever comes in between the double quotes ("......") as is in varchar field. Please suggest some ideas as how this can be achieved.
|2020-05-08 07:42:23+00||PG Bug reporting form||BUG #16424: COPY Command fails for CSV formath|
|2020-05-08 14:17:38+00||"David G(dot) Johnston"||Re: BUG #16424: COPY Command fails for CSV formath|