Thank you ! That's what I want and looking back in the sqlite documentation I can see now that I was misinterpreting it, in reality I was applying the same principle used on other places to qualify/prefix tables/views/... objects but with your help I could realize that pragmas are an exception to the genral rule.
? Again thank you ! ? > Fri Aug 21 2015 16:42:02 CEST from "Scott Hess" <shess at google.com> >Subject: Re: [sqlite] Is this a bug ? Pragmas do not accept qualified names ! > > I think you wanted: > PRAGMA attached_db.table_info(one_table); > > -scott > > On Fri, Aug 21, 2015 at 7:35 AM, sqlite-mail <sqlite-mail at dev.dadbiz.es> > wrote: > > >>Hello ! >> >> Today I'm working with sqlite3 with attached databases and when I tried to >> get info about a tbale using "PRAGMA TABLE_INFO" I discovered that pragmas >> do >> not work with qualified/prefixed names like: >> >> PRAGMA table_info(attached_db.one_table) >> >> >> >> Is this a bug ? >> >> Cheers ! >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ?
