From: | Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com> |
---|---|
To: | dsbw <dsbw(at)protonmail(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-14 03:51:43 |
Message-ID: | CAM9w-_=O3WcLnyiaG03Y+3kPx0iuR1AGTSZODyAW17kPGP52gg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
I got "email delivery failed" so replying again.
Did you try changing the escape field ? It is by default a single quote.
[image: image.png]
On Fri, May 14, 2021 at 12:14 AM dsbw <dsbw(at)protonmail(dot)com> wrote:
> OK, it's not as straightforward as an unpaired single quote. I just had
> one fail on:
>
> "PET'1'"
>
> So the single quote is paired, and caused the problem. So I changed it to
> "PET 1"...and the whole import worked. But I got suspicious and started
> looking at the data for single quotes and found things
> like "T'BIRD", "B--CH'N!!" and "JOHN'S WIFE" and those all worked.
>
> So I'm not sure what the deal is.
>
> Sent with ProtonMail <https://protonmail.com/> Secure Email.
>
> ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
> On Tuesday, May 11th, 2021 at 12:01 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===
>
>
>
--
Thanks,
Aditya Toshniwal
pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*
<http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"
From | Date | Subject | |
---|---|---|---|
Next Message | Akshay Joshi | 2021-05-14 06:08:13 | Re: PgAdmin doesn't quit on Mac |
Previous Message | Richard Brockie | 2021-05-13 19:30:56 | Re: PgAdmin doesn't quit on Mac |