Re: [sqlite] Extracting database schema information

2005-08-08 Thread Matthew Gertner
Thanks, Will, that's exactly what I was looking for. Will Leshner wrote: On Aug 8, 2005, at 5:14 AM, Matthew Gertner wrote: I'm wondering if there is a way to get information about the format of tables in an existing Sqlite database. Specifically, I would like to get the list of columns

Re: [sqlite] Extracting database schema information

2005-08-08 Thread Jay Sprenkle
Try this: select * from sqlite_master; On 8/8/05, Will Leshner <[EMAIL PROTECTED]> wrote: > > On Aug 8, 2005, at 5:14 AM, Matthew Gertner wrote: > > > I'm wondering if there is a way to get information about the format > > of tables in > > an existing Sqlite database. Specifically, I would like

Re: [sqlite] Extracting database schema information

2005-08-08 Thread Will Leshner
On Aug 8, 2005, at 5:14 AM, Matthew Gertner wrote: I'm wondering if there is a way to get information about the format of tables in an existing Sqlite database. Specifically, I would like to get the list of columns and the data type of each column. Check out the table_info PRAGMA on this

[sqlite] Extracting database schema information

2005-08-08 Thread Matthew Gertner
Hi, I'm wondering if there is a way to get information about the format of tables in an existing Sqlite database. Specifically, I would like to get the list of columns and the data type of each column. Obviously we can query the sqlite_master table and parse the CREATE TABLE statements ourselves,

[sqlite] C/C++ interpreter Ch bindings to sqlite

2005-08-08 Thread Peter Wu
Hello, We provide free C/C++ interpreter Ch. I wonder if it is possible that sqlite will bundle the ch bindings source code together for distribution. With the binding source code, the user can build the interface to Ch as needed with every new release of sqlite. Ch sqlite binding can build the i