Re: [sqlite] Is the table created by "create temp table" in the database file or in memory?

Also these links which maybe easier to grok: https://sqlite.org/tempfiles.html (sections 2.6 and 3) https://sqlite.org/tempfiles.html#tempstore -Neal On Sat, Feb 1, 2020 at 10:09 AM J. King wrote: > On February 1, 2020 10:03:28 a.m. EST, Peng Yu

Re: [sqlite] Is the table created by "create temp table" in the database file or in memory?

On February 1, 2020 10:03:28 a.m. EST, Peng Yu wrote: >But it doesn't explain what is "the temp database". Is it an actual >database file? Or it is just a in-memory database? It depends. See for details ans links to further reading. -- J.

Re: [sqlite] Is the table created by "create temp table" in the database file or in memory?

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 wrote: > On 1 Feb 2020, at 1:30pm, Peng Yu wrote: > >> https://www.sqlite.org/lang_createtable.html >> >> "The database in which the new table is

Re: [sqlite] Is the table created by "create temp table" in the database file or in memory?

On 1 Feb 2020, at 1:30pm, Peng Yu 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