Andrej Kastrin wrote:
||5354235||,||some text...|| ||1234567||,||some text...||
||1234568||,||some text...||
The sql statement I defined was:
COPY testtable FROM 'test.txt' WITH DELIMITER AS ',' CSV QUOTE AS
'||';
but the error:
ERROR: COPY quote must be a single ASCII character
I guess I'm stating the obvious here, but can you just change your
'||' quotes to a single character within the file?
Colin
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
