On Mon, 26 Jan 2015 19:26:49 +0000
Luke Niewiadomski <[email protected]> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
