The .import command doesn't play well with attempts to use tables in
schemas other than main:
sqlite> .mode csv
sqlite> .import test.csv temp.test
Error: no such table: temp.test
It creates the table if needed, but fails on the insert part because it
tries to execute `INSERT INTO "temp.test" ....` instead of `INSERT INTO
"temp"."test" ...`.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
