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

Too bad. Indeed, this should be files as a bug then. On 22-03-16 20:33, Gennadiy wrote:

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,