I have a few sqlite databases and .dump in the shell seems to work
fine for me (unless I have '.echo off')

I was preparing a test case to report the bug and I note that .dump
does not work on temp tables (3.24). Is this a feature?

sqlite> drop table if exists x;create temp table temp.x ( a integer ,
b integer); insert into x values (1,1),(2,2),(3,3);
sqlite> .dump x
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
COMMIT;
sqlite>

sqlite> drop table if exists x;create table x ( a integer , b
integer); insert into x values (1,1),(2,2),(3,3);
sqlite> .dump x
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE x ( a integer , b integer);
INSERT INTO x VALUES(1,1);
INSERT INTO x VALUES(2,2);
INSERT INTO x VALUES(3,3);
COMMIT;
sqlite>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to