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 <robin.cijvat@monetdbsolutions.com> 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;