The following bug has been logged online:
Bug reference: 5647
Logged by: David Sahagian
Email address: david.sahagian@gmail.com
PostgreSQL version: 9.0 beta4
Operating system: win XP
Description: COPY TO does not respect the
[standard_conforming_strings] setting
Details:
-
start the postgresql-9.0 service on my winXP laptop
-
verify that [standard_conforming_strings] = on
-
select a varchar(255) column from my table
using Query Tool of pgAdmin III
-
value displayed: my\n\m\\pq
this is expected by me
-
then do the COPY stmt
============
COPY( select mycol from silly_tbl )
TO $$c:\tmp\copy_to_bug.txt$$
WITH ( FORMAT text )
============
-
eyeball the output file using Notepad
value displayed: my\\n\\m\\\\pq
-
So all the backslash chars got "doubled".
My claim is . . .
if
standard_conforming_strings = on
then
COPY TO should NOT be modifying the data values
with extra backslashes
.
Notes:
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.
Thanks,
-dvs-
-dvs-
