Re: Import fails on single quote.
Think Before You Click: This email originated outside our organization.
OK, it's not as straightforward as an unpaired single quote. I just had one
fail on:
"PET'1'"
So the single quote is paired, and caused the problem. So I changed it
OK, it's not as straightforward as an unpaired single quote. I just had one
fail on:
"PET'1'"
So the single quote is paired, and caused the problem. So I changed it to "PET
1"...and the whole import worked. But I got suspicious and started looking at
the data for single quotes and found things
||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
wrote:
> B
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 q
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
