On 2 Jul 2018, at 12:45am, David Burgess <[email protected]> wrote:
> 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? The TEMP tables are not stored in the main database. They're in an attached database called 'temp'. Unfortunately the '.dump' command dumps only tables in the main database. I do not know whether '.dump temp.*' works. By definition these databases are not intended for permanent storage, so there's no point in dumping them to a file. But you might be able to see them using '.databases' and by using various PRAGMAs. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
