On 27/2/19 10:06 AM, Joshua Thomas Wise wrote: > 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”.
What does: SELECT sqlite_version(); return? From the link you posted: > The table-valued functions for PRAGMA feature was added in SQLite version > 3.16.0 (2017-01-02). Prior versions of SQLite cannot use this feature. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
