ERROR: COPY quote must be a single ASCII character

From: Andrej Kastrin <andrej(dot)kastrin(at)siol(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: ERROR: COPY quote must be a single ASCII character
Date: 2008-02-08 13:52:37
Message-ID: 47AC5EA5.3090807@siol.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message bh yuan 2008-02-08 14:02:36 Re: character conversion problem about UTF-8-->SHIFT_JIS_2004
Previous Message luca.ciciriello 2008-02-08 13:27:40 hyperthreading and pqlib