Copy function syntax on 8.1 - Mailing list pgsql-novice

From Mike G.
Subject Copy function syntax on 8.1
Date
Msg-id 20050830162218.GA9793@localhost.localdomain
Whole thread Raw
Responses Re: Copy function syntax on 8.1  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Copy function syntax on 8.1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Hi,

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
"nonstandard.." warning since file paths in Windows use the \ character.  I can clear the warning by changing the
syntaxto 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
returna warning if a \ is passed in the file path? 

Mike

pgsql-novice by date:

Previous
From: "Oren Mazor"
Date:
Subject: Re: array vs flat tables performance
Next
From: Bruce Momjian
Date:
Subject: Re: Copy function syntax on 8.1