how to copy a sqlite3 table to another file in python

Posted by james on Stack Overflow See other posts from Stack Overflow or by james
Published on 2011-01-15T15:47:35Z Indexed on 2011/01/15 15:53 UTC
Read the original article Hit count: 246

Filed under:

hey i was wondering how i could make a copy of a sqlite3 table and save it to a seperate file in python. im confused as in python your sqlite3 object can only be connected to one database so how would i make it save to a seperate database? the reason i want to do this is in sqlite3 the database file size can never get smaller, and ive made alot of changes so i want just copy this table to another file which wont have all the extra empty space and then delete the origonal database thanks guys

© Stack Overflow or respective owner

Related posts about sqlite3