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