Vertica Copy Local on Windows

Hi, 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

Hi, 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: http://confluence.dbvis.com/display/UG91/Importing+Table+Data Best Regards, Hans