litecli icon indicating copy to clipboard operation
litecli copied to clipboard

".separator" command missing

Open MatFluor opened this issue 4 years ago • 0 comments

When trying to load a CSV into a table, one might have to define the CSV-Separator used. Litecli throws a Syntaxerror.

in sqlite3 (working)

sqlite> .mode csv
sqlite> .separator ,
sqlite> .import examples/test.csv test
sqlite> .schema
CREATE TABLE test(
  "field_a" TEXT,
  "field_b" TEXT,
  "field_c" TEXT,
  "field_d" TEXT,
  "field_e" TEXT
);

in litecli (not working)

csvtest.db> .mode csv
Changed table format to csv
Time: 0.000s
csvtest.db> .separator ,
near ".": syntax error

MatFluor avatar Dec 16 '21 06:12 MatFluor