[This topic is migrated from our old forums. The original author name has been removed]
Does anyone know how to specify the file path for Vertica's COPY command if I am working on Windows? I have a CSV file I want to import that lives under D:/test.csv but for some reason DBVis doesn't see the file. My statement is as follows:
COPY newapi.email_subscribers FROM 'D:/test.csv' DELIMITER ',' DIRECT
over 9 years ago
[This reply is migrated from our old forums.]
Re: Vertica Copy Local on Windows
The command is executed by the database server so you must specify a path that it can see.
But DbVisualizer has it's own Import function that may be an alternative: