On 29 Mar 2018, at 1:47pm, Wout Mertens <[email protected]> wrote:
> I noticed that `.dump` does not output the user_version pragma. It seems to > me that that is part of the database data? > > I don't actually use it, but it might be interesting to add this for > completeness? .dump is for things which affect data and data integrity only. "PRAGMA foreign_keys" is one of the few PRAGMAs which affects data integrity: if a database is operated with that PRAGMA not set, the data could be corrupted. Numerous PRAGMAs have no effect on integrity. For example the journal mode and page size. They are not included in the output of .dump. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
