Re: Question on replace function [solved]

Hello Tom and Adrian

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Adrian Klaver
> Sent: Sonntag, 25. September 2016 18:38
> To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>; Charles Clavadetscher <clavadetscher(at)swisspug(dot)org>
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Question on replace function [solved]
>
> On 09/25/2016 08:39 AM, Tom Lane wrote:
> > Charles Clavadetscher <clavadetscher(at)swisspug(dot)org> writes:
> >> Honestly I still don't understand why this happened this way.
> >
> > I wonder if you have standard_conforming_strings turned off, or did
> > when that data was inserted. That would change the behavior of
> > backslashes in string literals.
>
> That got me to thinking:
>
> standard_conforming_strings = on

I checked the configuration and standard_conforming_strings is on and I did not change it before reading the data. The result looks
the same as you showed in the first test.
In a short test, trying to read the file with this setting off leads to other errors. Possibly I'll be able to make some more tests
later or in the evening and report.

Thank you for you input.
Charles