Re: Import fails on single quote.

2021-05-13 Thread dsbw
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

Re: Import fails on single quote.

2021-05-11 Thread dsbw
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: > >>

Import fails on single quote.

2021-05-11 Thread dsbw
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