Re: ERROR: COPY quote must be a single ASCII character

From: Colin Wetherbee <cww(at)denterprises(dot)org>
To: Andrej Kastrin <andrej(dot)kastrin(at)siol(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: COPY quote must be a single ASCII character
Date: 2008-02-08 14:42:53
Message-ID: 47AC6A6D.2050403@denterprises.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrej Kastrin 2008-02-08 15:06:28 Re: ERROR: COPY quote must be a single ASCII character
Previous Message Hiroshi Saito 2008-02-08 14:41:29 Re: character conversion problem about UTF-8-->SHIFT_JIS_2004