On 8 Dec 2017, at 7:02am, Peng Yu <pengyu...@gmail.com> wrote:
> I'd like to dump all the tables to separate files, one table one file. > Each file should be in TSV format. > > Is there a convenient way to do so in sqlite3? There’s no direct output from the SQLite library to produce TSV format. You could write one in your own programming language. Alternatively, you could script the SQLite Command-line tool to produce your .tsv files for you. Take a look at section 15 of <https://sqlite.org/cli.html> which you might want to use with .mode tabs Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
