On Sat, 13 Sep 2008 18:36:26 +0200, you wrote: >Exactly Stephen! I was trying to dump a database and I was wondering >how to deal with virtual tables. > >I think that a good way to dump a database skipping internally >generated real tables could be to: >- first create all tables that contains the CREATE VIRTUAL TABLE >statement >- then get the name of all the tables (not virtual) created inside the >db (save their names somewhere) >- and at the end copy all the tables whose name was not previously saved > >I wondering if is there a simpler/better solution...
Just a suggestion (wild guess, that is): Perhaps the rootpage column in sqlite_master can be of help? I don't have a virtual table handy to try it myself. select name,rootpage from sqlite_master where type = 'table' order by name; >--- >Marco Bambini >http://www.sqlabs.net >http://www.sqlabs.net/blog/ >http://www.sqlabs.net/realsqlserver/ -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
