On Fri, May 23, 2014 at 8:33 PM, Stephan Beal <sgb...@googlemail.com> wrote:

> FWIW, you can also use [table] instead of "table".
>

With, apparently, some corner-cases:

sqlite> create table [t] (a,b,c);
sqlite> insert into [t] values(1,2,3);

But...

sqlite> .dump [t]
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
COMMIT;

ooops!

sqlite> .dump t
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE [t] (a,b,c);
INSERT INTO "t" VALUES(1,2,3);
COMMIT;


-- 
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to