Wiki Page ConverterTools
... in your database:
$ pg_dump -a <dbname> -t <tablename> > /tmp/<dumpfile>
...and so on...
...
Wiki Page InMemoryDatabase
... copy each table to the target DB
foreach {tablename} [$dbhandle eval "SELECT name FROM loadf ...
Wiki Page PerformanceTuningWindows
... ents like:
DB.ExecSQL('INSERT OR REPLACE INTO tableName (Field1, Field2, Field 3) ' +
...
Wiki Page SqliteNetwork
... min
1::SHOW DATABASE
1::SHOW USER
1::SHOW TABLE [ tablename | viewname ]
1::SHOW INDEX [ tablename ] ...
Wiki Page UnsupportedSql
... d, language_id)
);
*:SHOW TABLES and DESCRIBE [tablename] would be nice - not sure if they're
sta ...
Wiki Page UnsupportedSqlSchemas
... n
(jill.importantTable)
would map to databasename.tablename in the current sqlite arrangement.
_::: ...
Wiki Page VirtualTables
... e table with a "module".
CREATE VIRTUAL TABLE tablename USING modulename;
You can also provide ...