On Wed, Aug 23, 2017 at 6:11 PM, Keith Medcalf <kmedc...@dessus.com> wrote:

>
> sqlite> pragma function_list;
> group_concat|1
> group_concat|1
> julianday|1
> julianday|1
> nullif|1
> nullif|1
> sqlite_compileoption_get|1
> sqlite_compileoption_get|1
> current_timestamp|1
> current_timestamp|1
> sqlite_compileoption_used|1
> sqlite_compileoption_used|1
>

Where's that pragma from Keith? Thanks, --DD

There's no such pragma at https://sqlite.org/pragma.html
and below you can see it's just as good as another, which pragma happily
ignores.

I've requested at least twice on this list for this pragma to be added, so
of course you picked my interested.
Given all the other pragmas to introspect SQLite, I'm still baffled SQLite
doesn't have this one.

If it was a security concern, there are ways to mitigate it IMHO
(authorizer, register "hidden" functions, etc...).

C:\Users\ddevienne>sqlite3
SQLite version 3.10.2 2016-01-20 15:27:19
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> pragma function_list;
sqlite> pragma foobar;
sqlite>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to