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
