[sqlite] Documentation is lying to me

[Joshua Thomas Wise]

In this SQLite3 documentation (https://www.sqlite.org/pragma.html#pragfunc), it 
says that information_schema could be implemented by doing something like this:

ATTACH ':memory:' AS 'information_schema';
CREATE VIEW information_schema.schemata(schema_name) AS
SELECT name FROM pragma_database_list();

However, when attempting to do this, we get an error: "no such table: 
information_schema.pragma_database_list”.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users