"Mike G." <mike(at)thegodshalls(dot)com> writes:
> In testing 8.1 I turned on the escape_string_warning. Now when I issue a COPY FROM / TO 'C:\\test' I am getting the "non standard.." warning since file paths in Windows use the \ character. I can clear the warning by changing the syntax to E'C:\\test'.
> Is their a way to properly escape the \ without using E or will the COPY function have to modified internally to not return a warning if a \ is passed in the file path?
Why do you think COPY should be modified? This is exactly the case that
the warning is intended to warn about.
regards, tom lane