Hello

        I'd like to save the output of SELECT into a tab-delimited text
file, and noticed that there are two commands that seem to do the same
thing:

sqlite> .mode tabs
sqlite> .separator \t
sqlite> .output myfile.tsv
sqlite> select * from mytable;
sqlite> .exit

What's the difference between mode and separator?

Thank you.

_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to