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.

Dan.



> Michael
> 
> 


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to