Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Getting Double Quotes on all strings when I load a string csv file

In my CSV file there are no double quotes, but once I load into Vertica, it starts showing "string" double quotes around my string for every value which is not what I want. I just want the normal string value.

COPY analysts.alerts_generated FROM LOCAL 'localfilepathblabla/alert_event.csv' ABORT ON ERROR DELIMITER ',' NULL AS 'null' SKIP 1 DIRECT STREAM NAME 'LOCAL_COPY_events_generated'


  • Bryan_HBryan_H Administrator

    Hi, could you provide more detail? What version of Vertica are you running, and what client are you using? Here is my simple attempt to replicate the issue, which seems OK:

    dbadmin=> create table public.alerts_generated (a int, b float, c varchar, d long varchar, e varbinary, f int);
    dbadmin=> COPY public.alerts_generated FROM LOCAL '/tmp/sample.csv' ABORT ON ERROR DELIMITER ',' NULL AS 'null' SKIP 1 DIRECT STREAM NAME 'LOCAL_COPY_events_generated';
     Rows Loaded
    (1 row)
    dbadmin=> select * from public.alerts_generated ;
     a  | b  |   c    |   d    |  e   | f
      1 |  2 | three  | four   | five |  6
      9 |  8 | seven  | six    | five |  4
     11 | 21 | eleven | twelve | ten  | 10
    (3 rows)
  • What tool are you using to select from? Is this in vsql, or something else? Your COPY command won't add quotes to your string. Maybe something else?

  • DBVisualizer Pro 10.0.21
    Should be something Vertica 9.0+ (9.2 )?

  • Bryan_HBryan_H Administrator

    For me, DbVis 10.0.21 doesn't show quotes in the grid, or when I copy a selection from the grid. However, you may need to disable quoting when you export using the wizard. About halfway down the dialog, check for the "quote text value" setting:

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.