Re: Is the table created by "create temp table" in the database file or in memory?
Peng Yu <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <CABrM6wkn9ozSy6CZL_GRGt3xO2wgOo0d4a7yWB3RWJBqj=gecQ@mail.gmail.com> |
But it doesn't explain what is "the temp database". Is it an actual database file? Or it is just a in-memory database? On 2/1/20, Simon Slavin <[email protected]> wrote: > On 1 Feb 2020, at 1:30pm, Peng Yu <[email protected]> wrote: > >> https://www.sqlite.org/lang_createtable.html >> >> "The database in which the new table is created. Tables may be created in >> the main database, the temp database, or in any attached database." >> >> It is not clear to me in the doc. If a table is created by "create >> temp table", is it temporarily a database file but later got deleted >> upon termination of the sqlite3 session? Or it is in memory? Thanks. > > Further down the same page: > > " If the "TEMP" or "TEMPORARY" keyword occurs between the "CREATE" and > "TABLE" then the new table is created in the temp database. " > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Regards, Peng _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users