On Sun, May 9, 2010 at 7:13 AM, Jay A. Kreibich <[email protected]> wrote: > On Sun, May 09, 2010 at 01:57:12PM +0200, Oliver Lange scratched on the wall: > > Richard Hipp wrote: > > > > The correct syntax is: > > > > > > PRAGMA main.table_info(mytable); > > > Aah, very nice. Just tried, works fine. Thank you very much. > > > > Shouldn't this be added to the PRAGMA doc? > > Already there: http://www.sqlite.org/pragma.html#syntax
Since the documentation got mentioned, how about changing (at that link) "The argument is may be either in parentheses or it may be ..." to "The argument may either be in parentheses or it may be ..." Also, the OP said the symptoms (using the incorrect syntax), were that the temp database information was retrieved. The documentation says that main is assumed with no database specified. Is that correct? or is temp the default (when something exists in both temp and main)? -- Phil _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
