On 8 Dec 2017, at 1:58pm, Peng Yu <pengyu...@gmail.com> wrote:

> Could you provide the working code for bash (on Mac OS X or linux)? Thanks.

Something like this …

sqlite3 myDatabase.sqlite > myTable.tsv << EOS
.mode tabs         
select * from myTable;
EOS

The first EOS must be at the very end of the line — no whitespace.
The first EOS must be the only thing on the line — no whitespace — and followed 
by the return character.

Alternatively put the tool commands in a script file and do

sqlite3 myDatabase.sqlite > myTable.tsv < myScript.txt

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to