ERROR: COPY quote must be a single ASCII character

[Andrej Kastrin <andrej.kastrin@xxxxxxxx>]

Dear all,

I have to copy the file with the following delimiters into the database:

||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

Any solution? Thank you in advance.

Best, Andrej

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq