|
I think I’ve found a bug in PG 8.0 that occurs while copying from CSV files. I checked the bugs list but didn’t see anything similar.
This occurs when reading a CSV file where one of the ‘text’ fields has a blank line. I included an example that shows the problem below. I found that if I change the blank line to have one space, pg reads it just fine.
If this is indeed a bug, if someone could let me know the best way to address it, I would appreciate it.
--EXAMPLE create table t ( id integer, description text );
copy t from stdin with null as '' csv quote as '"'; 1,"Now is the time" 2,"for all good men to come to the
aid of their party" 3,"The quick brown fox" \. --END EXAMPLE
The above example produces this output:
CREATE TABLE psql:test2.sql:8: ERROR: unterminated CSV quoted field CONTEXT: COPY t, line 5: ""
|
