Re: BUG #5647: COPY TO does not respect the [standard_conforming_strings] setting - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5647: COPY TO does not respect the [standard_conforming_strings] setting
Date
Msg-id 13094.1283880871@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5647: COPY TO does not respect the [standard_conforming_strings] setting  ("David Sahagian" <david.sahagian@gmail.com>)
Responses Re: BUG #5647: COPY TO does not respect the [standard_conforming_strings] setting  (Bruce Momjian <bruce@momjian.us>)
List pgsql-bugs
"David Sahagian" <david.sahagian@gmail.com> writes:
> Description:        COPY TO does not respect the
> [standard_conforming_strings] setting

This is not a bug.  The COPY format is well defined and is not going to
be changed by standard_conforming_strings.

> I want to use the output file as input to psql, for another db whose
> [standard_conforming_strings] is also = on. The current behavior of COPY TO
> makes that impossible.

That's nonsense.  standard_conforming_strings won't affect the
interpretation of COPY data on either machine.  If we were to change it
as you suggest, then we *would* have a compatibility problem.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "David Sahagian"
Date:
Subject: BUG #5647: COPY TO does not respect the [standard_conforming_strings] setting
Next
From: "Hannu Pohjanpalo"
Date:
Subject: Fw: BUG #5640: ODBC driver installed but not found