Mike G. wrote:
> 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?
The code is functioning exactly as described in the release notes,
mainly you have to use E'' for backslashes in strings. COPY will not be
modified to suppress those. It is working properly.
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2005-08-30 16:39:48|
|Subject: Re: Copy function syntax on 8.1 |
|Previous:||From: Mike G.||Date: 2005-08-30 16:22:18|
|Subject: Copy function syntax on 8.1|