Skip site navigation (1) Skip section navigation (2)

Re: Copy function syntax on 8.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mike G(dot)" <mike(at)thegodshalls(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Copy function syntax on 8.1
Date: 2005-08-30 16:39:48
Message-ID: 22656.1125419988@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"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

In response to

Responses

pgsql-novice by date

Next:From: Mike G.Date: 2005-08-30 17:25:22
Subject: Re: Copy function syntax on 8.1
Previous:From: Bruce MomjianDate: 2005-08-30 16:35:15
Subject: Re: Copy function syntax on 8.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group