||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.ascen...@gmail.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 <d...@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===
