PRAGMA help

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

PRAGMA help

Tony Papadimitriou
Is there some way to get a list of all available pragma options from the SQLite3 shell?
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: PRAGMA help

J Decker
On Sat, Dec 30, 2017 at 1:04 AM, Tony Papadimitriou <[hidden email]> wrote:

> Is there some way to get a list of all available pragma options from the
> SQLite3 shell?
>


https://sqlite.org/pragma.html

If it was built with SQLITE_INTROSPECTION_PRAGMAS, which by default it is
not.  and pragma_list is not documented in the before page.
pragma pragma_list
only shows the names, not the types or optiojns for those pragmas.

_______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users