Copy function syntax on 8.1

From: "Mike G(dot)" <mike(at)thegodshalls(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Copy function syntax on 8.1
Date: 2005-08-30 16:22:18
Message-ID: 20050830162218.GA9793@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 "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?

Mike

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruce Momjian 2005-08-30 16:35:15 Re: Copy function syntax on 8.1
Previous Message Oren Mazor 2005-08-30 14:40:32 Re: array vs flat tables performance