Answers

• Tim_1 ✭✭

  May 2020

  My bad, the separator should be a TAB, went missing from the original post

  0
• marcothesane - Select Field - Administrator

  May 2020

  I found it difficult to pass a 'tab' through the command line.

  My workaround is to cheat the tab character into an environment variable, using perl, and then to use it in the vsql command:
  For the export, two commands - note that, in the vsql call, all configuration switches come before the "-c" switch:

  $ export TAB=`perl -e 'print qq(\t)'`
  $  vsql -q -t -P format=unaligned -P fieldsep="$TAB"  -c "select * from foo limit 5"
  1.000000000000000   Arthur  Dent    2017-02-05 00:00:00
  2.000000000000000   Ford    Prefect 2017-02-05 00:00:00
  3.000000000000000   Zaphod  Beeblebrox  2017-02-05 00:00:00
  4.000000000000000   Tricia  McMillan    2017-02-05 00:00:00
  5.000000000000000   Gag Halfrunt    2017-02-05 00:00:00
  
  

  1
• Bryan_H Vertica Employee Administrator

  May 2020

  Yes, though you can also use \t as the delimiter to indicate TAB:

  copy myTable from stdin delimiter E'\t';

  1