Thanks to everyone for responding. I had turned off email delivery a few
months ago but forgot to turn it back on when I got back to working with
Sqlite again. Thanks Peter. I guess this means there is really nothing in
my code that needs to change other than replacing the explicit database
name in
On Thu, 24 Nov 2011 12:30:27 -0500, Pavel Ivanov
wrote:
>>> P.S: I know that one can simply do a CREATE TABLE IF NOT EXISTS... but I
>>> still need to know if a table exists or not.
>>
>> You can easily try this with the sqlite3 command line tool by omitting
>> the database file name argument on
rg] On Behalf Of Dilip Ranganathan
> Sent: Thursday, November 24, 2011 6:45 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Checking for existence of in-memory tables
>
> Currently I use sqlite to create a bunch of on-disk tables to store my
> data. I use Sqlite's maste
>> P.S: I know that one can simply do a CREATE TABLE IF NOT EXISTS... but I
>> still need to know if a table exists or not.
>
> You can easily try this with the sqlite3 command line tool by omitting
> the database file name argument on the command line.
> Create a table, insert a row, check sqlite_
On Thu, 24 Nov 2011 08:45:12 -0500, Dilip Ranganathan
wrote:
> Currently I use sqlite to create a bunch of on-disk tables to store my
> data. I use Sqlite's master table to determine if a table already exists
> based on which I take certain decisions.
>
> Suppose I switch these to in-memory table
Currently I use sqlite to create a bunch of on-disk tables to store my
data. I use Sqlite's master table to determine if a table already exists
based on which I take certain decisions.
Suppose I switch these to in-memory tables (:memory:), how do I go about
checking if a table exists? Do in-memory
6 matches
Mail list logo
