Re: Import fails on single quote.

Поиск
Список
Период
Сортировка
От richard coleman
Тема Re: Import fails on single quote.
Дата
Msg-id CAGA3vBtLWz8W3Wya_8z4enQjKv4=6AC98Jeo2C8+=cVtTz+p1g@mail.gmail.com
обсуждение исходный текст
Ответ на Import fails on single quote.  (dsbw <dsbw@protonmail.com>)
Ответы Re: Import fails on single quote.  (dsbw <dsbw@protonmail.com>)
Список pgadmin-support
Blake, 

You might want to try escaping the single quotes in your data.  Either by doubling them up or switching double quotes for dollar-quoted strings.

Just a thought, 

rik.



On Tue, May 11, 2021 at 3:02 PM dsbw <dsbw@protonmail.com> wrote:
Hello,

Trying to import data, tab-delimited but unfortunately with quotes around string fields anyway. Like:

1234<tab>"JOHN"<tab>"SMITH"<tab>5678

PGAdmin import fails when the quoted value contains a single quote:

1234<tab>"EMPLOYEES'"<tab>"CREDIT UNION"<tab>5678

So the trailing quote (for possessive) after "EMPLOYEES" trips it up. Seems like, if one is inside a set of double-quotes, any single quotes should be ignored? (I know CSV is multiply and contradictorily defined, but still.)

===Blake===

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

Предыдущее
От: dsbw
Дата:
Сообщение: Import fails on single quote.
Следующее
От: Aditya Toshniwal
Дата:
Сообщение: Re: Import fails on single quote.