--- Dan Kennedy <[EMAIL PROTECTED]> wrote: > On Tue, 2007-02-27 at 10:48 +0100, Michael Schlenker wrote: > > Hi all, > > > > for some uses its nice to query the PRAGMA and the sqlite_master table > > with a single query instead of multiple PRAGMA statements. > > > > Could the Pragmas to query the database schema be converted to virtual > > tables? (that would enable joins with sqlite_master and other nice uses > > to get all schema info for a table with a single statement). > > > > Or did some already do something like that? > > There is some code for an sqlite extension in the src/test_schema.c of > the distribution that provides a read-only view of the database schema > as a virtual table.
Are there any plans to make all SQLite PRAGMA meta-data information available via virtual tables as part of the standard sqlite library? (with OMIT_META_DATA_IN_VIRTUAL_TABLES and all that?) Everyone could roll their own easily enough, but everyone's implementation would be different. ____________________________________________________________________________________ We won't tell. Get more on shows you hate to love (and love to hate): Yahoo! TV's Guilty Pleasures list. http://tv.yahoo.com/collections/265 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------