"ed" <epdm...@gmail.com> wrote in message news:d92e64410905221021p39a4f833y960370145e187...@mail.gmail.com > I have an application that copies my disk based db into an in memory > table (":memory:") using the command > "create table mem_db as select * from file_db;" > > The problem is the disk db has a column set to INTEGER PRIMARY KEY, > but this is not preserved when the new in memory db is created. When i > do a "select * from sqlite_master;" on the in-memory db, there is no > IPK. How can I accomplish creating the in-memory db with the file db > data and preserve the column configuration from the original table?
You create the table the way you want it, then run INSERT ... SELECT statement to populate it. You may also find this interesting: http://sqlite.org/c3ref/backup_finish.html Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
