dbcli / dbcli/litecli

".separator" command missing

Open
#123 0 comments 2 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
3.3k
Forks
95
PR merge metrics
No merged PRs in 30d

Description

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

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.