The following bug has been logged online: Bug reference: 5647 Logged by: David Sahagian Email address: david.sahag...@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- -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs