Michele Simionato said: > I forgot to say that I would like a solution working from sqlite3, the > console, not from the > programming interface. For instance, I may want to pipe the SQL code to > sqlite3 from a CGI script, or just make some interactive exploration.
You don't want this. You may think you want this, but shelling out to sqlite3 to perform queries for another program is a sub-optimal solution and opens you up to major performance and security problems. I have code at http://www.ceamus.com/objbuilder/ which can show you how to get your table structure. Download the package, extract, and look for sqliteschema.c. The example code is written in C, but the interface should be similar enough to whatever interface library you're using that you can get the information you want. Also, sqliteschema.c all by itself will spew the data you're looking for into an XML file. Clay Dowling -- Simple Content Management http://www.ceamus.com
