Re: Import fails on single quote.
| От | dsbw |
|---|---|
| Тема | Re: Import fails on single quote. |
| Дата | |
| Msg-id | BXqyRtZPH6ZQ3CKKnoiKAbUS-ApxoeiGAg9koPUAb_Re-IAEFmttiSNhGaHbd1WDaqQzNHqmLDgOIFETkf9fVrL3YzMnnjDQw8Lbw5g9Qwg=@protonmail.com обсуждение исходный текст |
| Ответ на | Re: Import fails on single quote. (richard coleman <rcoleman.ascentgl@gmail.com>) |
| Список | pgadmin-support |
||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.||
It's not my data. That's why I'm importing it.
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Tuesday, May 11th, 2021 at 12:16 PM, richard coleman <rcoleman.ascentgl@gmail.com> wrote:
On Tuesday, May 11th, 2021 at 12:16 PM, richard coleman <rcoleman.ascentgl@gmail.com> wrote:
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>5678PGAdmin import fails when the quoted value contains a single quote:1234<tab>"EMPLOYEES'"<tab>"CREDIT UNION"<tab>5678So 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 по дате отправления: