Joshuas-MBP:sqldark josh$ sqlite3 SQLite version 3.25.0 2018-09-15 04:01:47 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> SELECT sqlite_version(); 3.25.0 sqlite> ATTACH ':memory:' AS 'information_schema'; sqlite> CREATE VIEW information_schema.schemata(schema_name) AS ...> SELECT name FROM pragma_database_list(); sqlite> select * from schemata; Error: no such table: information_schema.pragma_database_list sqlite> select * from pragma_database_list(); 0|main| 2|information_schema|
It worked when using `pragma_database_list()` directly, but not from inside the view. > On Feb 26, 2019, at 9:26 PM, Keith Medcalf <kmedc...@dessus.com> wrote: > > > 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
