How do I get a list of tables, the schema, a dump, using the sqlite3 API?

Asked 2008-11-20T14:00:23.947

214

How do I get the equivalents of SQLite's interactive shell commands .tables and .dump using the Python sqlite3 API?

python sqlite dump

Edit Report

1 Answer

I'm not familiar with the Python API but you can always use

SELECT * FROM sqlite_master;

answered 2008-11-20T14:07:20.437