Unable to reproduce: >sqlite SQLite version 3.28.0 2019-02-25 18:43:54 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> ATTACH ':memory:' AS 'information_schema'; sqlite> CREATE VIEW information_schema.schemata(schema_name) AS ...> SELECT name FROM pragma_database_list(); sqlite> sqlite> select * from schemata; main information_schema sqlite> .exit
What version of SQLite are you using? What do the following commands do? pragma database_list; select * from pragma_database_list(); --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Joshua Thomas Wise >Sent: Tuesday, 26 February, 2019 19:06 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] Documentation is lying to me > >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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
