[This topic is migrated from our old forums. The original author name has been removed]
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
1 Comment
Hans Bergsten
said
about 10 years ago
[This reply is migrated from our old forums.]
Re: Vertica Copy Local on Windows
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
anonymous