| From: | dsbw <dsbw(at)protonmail(dot)com> |
|---|---|
| To: | richard coleman <rcoleman(dot)ascentgl(at)gmail(dot)com> |
| Cc: | "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Import fails on single quote. |
| Date: | 2021-05-12 05:13:30 |
| Message-ID: | BXqyRtZPH6ZQ3CKKnoiKAbUS-ApxoeiGAg9koPUAb_Re-IAEFmttiSNhGaHbd1WDaqQzNHqmLDgOIFETkf9fVrL3YzMnnjDQw8Lbw5g9Qwg=@protonmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)ascentgl(at)gmail(dot)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(at)protonmail(dot)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===
| From | Date | Subject | |
|---|---|---|---|
| Next Message | androxkentaki | 2021-05-12 06:32:56 | Re: pgAdmin 4 v5 Crashes on right click in Query window |
| Previous Message | Aditya Toshniwal | 2021-05-12 05:05:36 | Re: Import fails on single quote. |