The following dump cannot be used to rebuild the database because the column name is not properly quoted giving an error.
To reproduce:
sql xxx.db "CREATE TABLE xxx(`time zone`)" "insert into xxx values('1')"
sql .dump xxx.db | sql
Error: near line 4: near "zone": syntax error
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
