Re: [sqlite] pragma table_info(database.table) not supported

2013-03-25 Thread Petite Abeille
On Mar 21, 2013, at 6:41 PM, Peter Haworth wrote: > I found the code in the two attached files (are they allowed on this list?) > on the web a while back. The claim was that it created an information > schema database from an sqlite db. I know nothing about Lua but I managed >

Re: [sqlite] pragma table_info(database.table) not supported

2013-03-22 Thread Simon Slavin
On 21 Mar 2013, at 5:41pm, Peter Haworth wrote: > I found the code in the two attached files (are they allowed on this list?) You can't attach things to messages to this list. Thanks for finding the code. I think it's interesting as a talking point but we don't actually need

Re: [sqlite] pragma table_info(database.table) not supported

2013-03-22 Thread Peter Haworth
e Database <sqlite-users@sqlite.org> > Subject: Re: [sqlite] pragma table_info(database.table) not supported > Message-ID: <c9f4c996-f601-4080-a23c-7dc5c58e7...@bigfraud.org> > Content-Type: text/plain; charset=us-ascii > > > On 20 Mar 2013, at 6:52pm, Petite Abeille <

Re: [sqlite] pragma table_info(database.table) not supported

2013-03-20 Thread Simon Slavin
On 20 Mar 2013, at 6:52pm, Petite Abeille wrote: > On Mar 20, 2013, at 6:53 PM, Jay A. Kreibich wrote: > >> If there is any change I'd like to see, it is that all the PRAGMAs >> that return tabular data should really be system catalog tables. > >

Re: [sqlite] pragma table_info(database.table) not supported

2013-03-20 Thread Petite Abeille
On Mar 20, 2013, at 6:53 PM, Jay A. Kreibich wrote: > If there is any change I'd like to see, it is that all the PRAGMAs > that return tabular data should really be system catalog tables. Triple hurray for that! SQLite deserves a proper data dictionary, no question asked.

Re: [sqlite] pragma table_info(database.table) not supported

2013-03-20 Thread Jay A. Kreibich
On Wed, Mar 20, 2013 at 07:00:29PM +0100, Stephan Beal scratched on the wall: > On Wed, Mar 20, 2013 at 6:53 PM, Jay A. Kreibich wrote: > > > That way I can use WHERE on them. In the past I've used virtual > > tables to wrap the PRAGMAs into something that looked and acted

Re: [sqlite] pragma table_info(database.table) not supported

2013-03-20 Thread Stephan Beal
On Wed, Mar 20, 2013 at 6:53 PM, Jay A. Kreibich wrote: > That way I can use WHERE on them. In the past I've used virtual > tables to wrap the PRAGMAs into something that looked and acted more > like a real table. > Hi, Jay, can you give us an example of how that is

Re: [sqlite] pragma table_info(database.table) not supported

2013-03-20 Thread Jay A. Kreibich
On Wed, Mar 20, 2013 at 05:57:12PM +0100, Staffan Tylen scratched on the wall: > >PRAGMA table_info(database.tablename) > > > > Any chance that SQLite4 might change this, or perhaps accept both forms ? > In addition, how about a pragma to get the tables in a database? We > currently have

Re: [sqlite] pragma table_info(database.table) not supported

2013-03-20 Thread Staffan Tylen
>PRAGMA table_info(database.tablename) > > Any chance that SQLite4 might change this, or perhaps accept both forms ? > > In addition, how about a pragma to get the tables in a database? We currently have pragma(database_list), pragma(index_list), and pragma(table_info), but no

Re: [sqlite] pragma table_info(database.table) not supported

2013-03-20 Thread Simon Slavin
On 20 Mar 2013, at 11:03am, Richard Hipp wrote: > The syntax for PRAGMA is: > >PRAGMA database.table_info(tablename); Out of interest, is there some internal reason for this non-standard form ? I can understand it if it makes some internal part of SQLite easier to

Re: [sqlite] pragma table_info(database.table) not supported

2013-03-20 Thread Staffan Tylen
Ooops! Thank :) On Wed, Mar 20, 2013 at 12:03 PM, Richard Hipp wrote: > On Wed, Mar 20, 2013 at 6:54 AM, Staffan Tylen >wrote: > > > I've just found out that adding a database name as a table prefix is not > > supported by the pragma table_info

Re: [sqlite] pragma table_info(database.table) not supported

2013-03-20 Thread Richard Hipp
On Wed, Mar 20, 2013 at 6:54 AM, Staffan Tylen 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

Re: [sqlite] pragma table_info(database.table) not supported

2013-03-20 Thread Clemens Ladisch
Staffan Tylen 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. : PRAGMA mydatabase.table_info(mytable); Regards, Clemens