Re: plpgsql copy import csv double quotes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: plpgsql copy import csv double quotes
Дата
Msg-id 17097.1570660277@sss.pgh.pa.us
обсуждение исходный текст
Ответ на plpgsql copy import csv double quotes  (PASCAL CROZET <pascal.crozet@qualis-consulting.com>)
Ответы RE: plpgsql copy import csv double quotes  (PASCAL CROZET <pascal.crozet@qualis-consulting.com>)
Список pgsql-general
Дерево обсуждения 
PASCAL CROZET <pascal.crozet@qualis-consulting.com> writes:
> I’ve experience issues with double quotes \34 inside fields, in a csv file.

> Ex :
> "value1","some text","other text with "double quotes" inside","last field"

I don't know of any definition of CSV format by which that's legal data.
The typical rule is that double quotes that are data must be doubled;
at least, that's what COPY expects by default.  You can also get COPY
to handle variants like backslash-quote.

            regards, tom lane

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

Предыдущее
От: Pól Ua Laoínecháin
Дата:
Сообщение: Re: Is my lecturer wrong about PostgreSQL? I think he is!
Следующее
От: Thiemo Kellner
Дата:
Сообщение: pgutils, pglogger and pgutilsL out