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

From dsbw
Subject Import fails on single quote.
Date
Msg-id YJ_4X595eZAio_41qyqoFY7aZcFP4zOwhJvBXQV04NgpdJC_gghwexbrnkbTdGVw88teKTHpZCU2VkkwwzBe5XLpJ6xLofpNeAfjS3vF6nU=@protonmail.com
Whole thread Raw
Responses Re: Import fails on single quote.
Re: Import fails on single quote.
Re: Import fails on single quote.
List pgadmin-support
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 by date:

Previous
From: androxkentaki
Date:
Subject: Re: pgAdmin 4 v5 Crashes on right click in Query window
Next
From: richard coleman
Date:
Subject: Re: Import fails on single quote.