On Wed, Mar 20, 2013 at 6:54 AM, Staffan Tylen <staffan.ty...@gmail.com>wrote:
> I've just found out that adding a database name as a table prefix is not
> supported by the pragma table_info function, giving a syntax error. The
> documentation of the ATTACH DATABASE commands says:
>
> Tables in an attached database can be referred to using the syntax *
> database-name.table-name*.
>
> This doesn't seem to be true for the table_info pragma. Can this by any
> chance be added to the pragma, or is there an alternative way to retrieve
> the information without parsing the information in the sqlite_master table?
>
The syntax for PRAGMA is:
PRAGMA database.table_info(tablename);
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
