Re: [sqlite] Schema of an attached database

2004-10-05 Thread Eddy Macnaghten
Wow - that was fast! Any plans for a 3.0.8? Eddy On Tue, 2004-10-05 at 16:44, D. Richard Hipp wrote: > Eddy Macnaghten wrote: > > This does not seem to work for 3.0.7 > > > > > >>Marc Pitoniak wrote: > >> > >>>To get the schema of a table T from A I've tried "PRAGMA table_info('A.T') " >

Re: [sqlite] Schema of an attached database

2004-10-05 Thread D. Richard Hipp
Eddy Macnaghten wrote: This does not seem to work for 3.0.7 Marc Pitoniak wrote: To get the schema of a table T from A I've tried "PRAGMA table_info('A.T') " among other things without any success. PRAGMA A.table_info(T); Fixed with check-in [2001]

Re: [sqlite] Schema of an attached database

2004-10-05 Thread Eddy Macnaghten
This does not seem to work for 3.0.7 If you have a table named "t" in the main database, and you attach a database that has a table named t in it as attachdb, then pragma attachdb.table_info(t); still seems to give the info for the table t in the main database. Is this a bug or have I got it

RE: [sqlite] Schema of an attached database

2004-10-05 Thread Marc Pitoniak
Thank you very much. -Marc -Original Message- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 05, 2004 8:09 AM To: [EMAIL PROTECTED] Subject: Re: [sqlite] Schema of an attached database Marc Pitoniak wrote: > > To get the schema of a table T from A I've

Re: [sqlite] Schema of an attached database

2004-10-05 Thread D. Richard Hipp
Marc Pitoniak wrote: To get the schema of a table T from A I've tried "PRAGMA table_info('A.T') " among other things without any success. PRAGMA A.table_info(T); -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565