Re: How to quote/escape single quote character in the name of the file?

22 Mar 2016

      I already tried to precede the single quote character by a \ (backslash):

sql>COPY 120 OFFSET 2 RECORDS INTO "observations_to_score1" FROM 'C:\\tmp\\sachin\'s_data_with_requested_column_03_03_2016.csv' USING DELIMITERS ',', '\n', '"' LOCKED;
could not open file 'C:\\tmp\\sachin\'s_data_with_requested_column_03_03_2016.csv': No such file or directory
sql>

Thank you,
-- 
Gennadiy

On Tue, 22 Mar 2016 20:12:12 +0100
Robin Cijvat  wrote:
...
It seems to me that you should escape this quote, since you use the same
single quotes to surround your file path, hence the sql interpreter
thinks you are still inside a string when you hit enter. What happens if
you try this:
COPY 120 OFFSET 2 RECORDS INTO "observations_to_score1" FROM 'C:\\tmp\\sachin\'s_data_with_requested_column_03_03_2016.csv' USING DELIMITERS ',', '\n', '"' LOCKED;