On 29 May 2014, at 10:59am, big stone <[email protected]> wrote: > I would like to save my sqlite ':memory:' database into a sql command text > file.
There are no functions built into SQLite which turn schema or data into SQL commands. The Shell Tool can do it, but the code which does it is built into the shell tool, not the SQLite API. I have written code in JavaScript which does what you describe (apart, of course, from stored procedures which don't exist in SQLite) but I had to do just that: write my own code. I argued some years ago that SQLite could usefully include such a function but people didn't seem to think it would be worth the extra code size. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
