he 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 Tuesd
coleman
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 wrote:
>
>>
Hello,
Trying to import data, tab-delimited but unfortunately with quotes around
string fields anyway. Like:
1234"JOHN""SMITH"5678
PGAdmin import fails when the quoted value contains a single quote:
1234"EMPLOYEES'""CREDIT UNION"5678
So the trailing quote (for possessive) after "EMPLOYEES" tr