On Mon, Jul 19, 2010 at 01:27:52AM -0400, Sam Carleton scratched on the wall: > Is there any way to use the PRAGMA database_list in a query? What I would > like to do is: > > SELECT * FROM (PRAGMA database_list) WHERE name = 'EventDB';
One of the virtual tables examples in "Using SQLite" wraps PRAGMA database_list in a virtual table so that you can do just this. Of course, it calls PRAGMA database_list interally, so it isn't any faster than doing it yourself. http://www.amazon.com/Using-SQLite-Jay-Kreibich/dp/0596521189/ (Next month!) -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
