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

Re: Copy function syntax on 8.1

From: Bruce Momjian <pgman(at)candle(dot)pha(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:35:15
Message-ID: 200508301635.j7UGZF717292@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Mike G. wrote:
> 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 "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 LaneDate: 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

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