dbReadTable-methods {RSQLite} | R Documentation |
These functions mimic their R/S-Plus counterpart
get
,
assign
,
exists
,
remove
, and
objects
,
except that they generate code that gets remotely executed
in a database engine.
A data.frame in the case of dbReadTable
; otherwise a logical
indicating whether the operation was successful.
These RSQLite methods do not use transactions, thus it is dangerous
to specify overwrite=TRUE
in dbWriteTable
(the
table is first removed and in case the data exporting fails
the original table is lost forever).
Note that the data.frame returned by dbReadTable
only has
primitive data, e.g., it does not coerce character data to factors.
SQLite table names are not case sensitive, e.g., table
names ABC
and abc
are considered equal.
See the Database Interface definition document
DBI.pdf
in the base directory of this package
or http://stat.bell-labs.com/RS-DBI.
sqliteImportFile
,
SQLite
,
dbDriver
,
dbConnect
,
dbSendQuery
,
dbGetQuery
,
fetch
,
dbCommit
,
dbGetInfo
,
dbListTables
,
dbReadTable
.
## Not run: conn <- dbConnect("SQLite", dbname = "sqlite.db") if(dbExistsTable(con, "fuel_frame")){ dbRemoveTable(conn, "fuel_frame") dbWriteTable(conn, "fuel_frame", fuel.frame) } if(dbExistsTable(conn, "RESULTS")){ dbWriteTable(conn, "RESULTS", results2000, append = TRUE) else dbWriteTable(conn, "RESULTS", results2000) } ## End(Not run)