SQLite3 trapping OperationalError

paul paul at subsignal.org
Sat Mar 10 06:10:39 EST 2007


jim-on-linux schrieb:
> pyhelp,
> 
> I set up a table in SQLite3.
> 
> While running other modules I want to know if a  
> table exists.
> 
> SQL has a command "List Tables" but I don't think 
> SQLlite3 has this command.
I think "list tables" is a mysqlism

> 
> I've tried 
>    cursor.execute("select * from debtor where key
>     is not null ")
FROM sqlite_master SELECT name WHERE type='table';

cheers
 Paul




More information about the Python-list mailing list