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"
>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
> 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
>
>
>
?