ERROR: COPY quote must be a single ASCII character

Поиск
Список
Период
Сортировка
От Andrej Kastrin
Тема ERROR: COPY quote must be a single ASCII character
Дата
Msg-id 47AC5EA5.3090807@siol.net
обсуждение исходный текст
Ответы Re: ERROR: COPY quote must be a single ASCII character
Список 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

В списке pgsql-general по дате отправления: