[DB-SIG] Getting a list of tables from a database

2012-05-14 Thread Edward Welbourne
Hi DB-sig, I'm digging data out of my mobile 'phone so that I don't lose it during an upgrade. It turns out to hold my address-book in a sqlite database, so I duly connected to that using the pysqlite2 package; which implements PEP 249 (DB API 2.0) - indeed, the nearest it gets to documentation w

Re: [DB-SIG] Getting a list of tables from a database

2012-05-14 Thread Vernon Cole
Eddy: As you discovered, every different database system has a unique way of getting a table listing. The problem with attempting to make a uniform tool for doing that at the PEP 249 level, is that some api packages (such as the one I maintain for Microsoft ADO, and anything that does ODBC) may

Re: [DB-SIG] Getting a list of tables from a database

2012-05-14 Thread Andy Todd
On 15/05/12 12:06 PM, Vernon Cole wrote: Eddy: As you discovered, every different database system has a unique way of getting a table listing. The problem with attempting to make a uniform tool for doing that at the PEP 249 level, is that some api packages (such as the one I maintain for Micr

Re: [DB-SIG] Getting a list of tables from a database

2012-05-14 Thread M.-A. Lemburg
Edward Welbourne wrote: > Hi DB-sig, > > I'm digging data out of my mobile 'phone so that I don't lose it during > an upgrade. It turns out to hold my address-book in a sqlite database, > so I duly connected to that using the pysqlite2 package; which > implements PEP 249 (DB API 2.0) - indeed, th