> On 8 Apr 2017, at 12:44am, Tony Papadimitriou <to...@acm.org> wrote:
>
> So, please try this instead:
>
> sql xxx.db ".headers on" ".dump"
sqlite> .headers on
sqlite> CREATE TABLE xxx(`time zone`);
sqlite> insert into xxx values('1');
sqlite> .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE xxx(`time zone`);
INSERT INTO xxx(time zone) VALUES('1');
COMMIT;
sqlite>
Yes, you have isolated the problem. Without ".headers on" you get
INSERT INTO xxx VALUES('1');
But with ".headers on" you get
INSERT INTO xxx(time zone) VALUES('1');
However, it is not quoting the column name, so the command is invalid.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
