Hello,
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?
I am using SQLite 3.3.4.
--
thanks,
ed
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
