On Mon, 26 Jan 2015 19:26:49 +0000 Luke Niewiadomski <lniewiadom...@thezerobase.com> wrote:
> I am looking to translate *.sqlite3 files into *.csv, or similar > format. Would you be willing to point me in the right direction? I > appreciate any help on this. for T in $(sqlite3 -noheader $DB "select name from SQLITE_MASTER where type = 'table'"); do sqlite3 -csv db "select * from $T" > ${DB}.$T.csv done That's the command you want, subsituting your database name for "$DB". I can appreciate that it's not easy to read if you don't know Bourne shell syntax, but if you can find someone who does, that will produce one csv file for every table in the database. HTH. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users