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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2005-08-30 16:39:48 Re: Copy function syntax on 8.1
Previous Message Mike G. 2005-08-30 16:22:18 Copy function syntax on 8.1