Apparently the CSV virtual table supports neither changes (INSERT, UPDATE, DELETE), nor reading single column csv files.
What I really want is the functionality of .import and .output SQLite shell commands. Maybe a better strategy would be to compile shell.c with my c program and call the function do_meta_command(char *zLine, ShellState *p). To those familiar with shell.c, is this a reasonable approach? On 17 January 2018 at 00:15, Richard Hipp <d...@sqlite.org> wrote: > On 1/16/18, Shane Dev <devshan...@gmail.com> wrote: > > I tried - > > > > sqlite> CREATE VIRTUAL TABLE temp.t1 USING csv(filename='test.tsv'); > > > > where test.tsv is a tab separated table. However > > > > select count(*) from t1; > > > > goes into an infinite loop. Do you how to specify a separator other than > > ","? > > The "C" in CSV stands for "Comma". That is the only separator > supported. But, you can probably edit the source code to do something > different. > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users