dbReadTable,SQLiteConnection,character-method {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.
## S4 method for signature 'SQLiteConnection,character' dbReadTable(conn, name, row.names, check.names = TRUE, select.cols = "*")
conn |
a |
name |
a character string specifying a table name. SQLite table names
are not case sensitive, e.g., table names |
row.names |
A string or an index specifying the column in the DBMS table
to use as |
check.names |
If |
select.cols |
A SQL statement (in the form of a character vector of length 1) giving the columns to select. E.g. "*" selects all columns, "x,y,z" selects three columns named as listed. |
A data.frame in the case of dbReadTable
; otherwise a logical
indicating whether the operation was successful.
Note that the data.frame returned by dbReadTable
only has
primitive data, e.g., it does not coerce character data to factors.
con <- dbConnect(SQLite()) dbWriteTable(con, "mtcars", mtcars) dbReadTable(con, "mtcars") # Supress row names dbReadTable(con, "mtcars", row.names = FALSE) dbDisconnect(con)