On Mon, Jul 19, 2010 at 4:02 PM, Jay A. Kreibich <j...@kreibi.ch> wrote: > 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';
I thought I had tried that and it didn't work, guess I had my syntax wrong. > 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. Well, faster is relative. I am as concerned with programmers speed to get something done as I am with the database's speed:) If I can write one line of SQL code to do all the work for me so I have to write less C/C++ code, all the better! (This coming from someone that stayed clear of SQL databases until the beginning of last year!) Sam _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
