Interesting. Must be that the pragmas that take arguments need parens when used in table valued function form. I've never tried without them when using a pragma that way.
Anyways, the sqlite3 shell is built with that introspection option, at least on Linux (tested with one built from source myself without any special configure arguments, and the stock Ubuntu one). I don't have a Windows version handy to test right now. It's apparently different for some reason? On Wed, Apr 10, 2019, 3:46 AM Graham Holden <sql...@aldurslair.com> wrote: > Wednesday, April 10, 2019, 11:16:07 AM, Shawn Wagner < > shawnw.mob...@gmail.com> wrote: > > > It should be pragma_function_list(). Note the parentheses. > > That doesn't make a difference if the shell hasn't been built with > -DSQLITE_INTROSPECTION_PRAGMAS, and they don't appear necessary for a > pragma that IS built-in (such as "pragma_database_list"): > > SQLite version 3.27.2 2019-02-25 16:06:06 > Enter ".help" for usage hints. > sqlite> select * from pragma_database_list; > 0|main|X:\V1LS\z > sqlite> select * from pragma_database_list(); > 0|main|X:\V1LS\z > sqlite> select * from pragma_function_list ; > Error: no such table: pragma_function_list > sqlite> select * from pragma_function_list() ; > Error: no such table: pragma_function_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
