Postgres Pro
Downloads
Home   >   mailing lists

Re: Import fails on single quote. - Mailing list pgadmin-support

From Aditya Toshniwal
Subject Re: Import fails on single quote.
Date
Msg-id CAM9w-_=VXdX0anWGXH_3gsR3EJjneGkgmmbKOR_ePz2UCQThOg@mail.gmail.com
Whole thread Raw
In response to Import fails on single quote.  (dsbw <dsbw@protonmail.com>)
List pgadmin-support
Tree view
Hi Dsbw,

Did you try changing the escape field ? It is by default a single quote.
image.png

On Wed, May 12, 2021 at 12:32 AM 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===


--
Thanks,
Aditya Toshniwal
pgAdmin hacker | Sr. Software Engineer | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"
Attachment

pgadmin-support by date:

Previous
From: richard coleman
Date:
Subject: Re: Import fails on single quote.
Next
From: dsbw
Date:
Subject: Re: Import fails on single quote.