| From: | dsbw <dsbw(at)protonmail(dot)com> |
|---|---|
| To: | "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
| Subject: | Import fails on single quote. |
| Date: | 2021-05-11 19:01:53 |
| Message-ID: | YJ_4X595eZAio_41qyqoFY7aZcFP4zOwhJvBXQV04NgpdJC_gghwexbrnkbTdGVw88teKTHpZCU2VkkwwzBe5XLpJ6xLofpNeAfjS3vF6nU=@protonmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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===
| From | Date | Subject | |
|---|---|---|---|
| Next Message | richard coleman | 2021-05-11 19:16:04 | Re: Import fails on single quote. |
| Previous Message | androxkentaki | 2021-05-11 11:25:03 | Re: pgAdmin 4 v5 Crashes on right click in Query window |