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

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