DBI (version 0.5-1)

dbReadTable: Copy data frames to and from database tables

Description

dbReadTable: database table -> data frame; dbWriteTable: data frame -> database table.

Usage

dbReadTable(conn, name, ...)
dbWriteTable(conn, name, value, ...)

Arguments

conn

A DBIConnection object, as produced by dbConnect.

name

A character string specifying a DBMS table name.

...

Other parameters passed on to methods.

value

a data.frame (or coercible to data.frame).

Value

a data.frame.

See Also

Other DBIConnection generics: DBIConnection-class, dbDataType, dbDisconnect, dbExecute, dbExistsTable, dbGetException, dbGetInfo, dbGetQuery, dbIsValid, dbListFields, dbListResults, dbListTables, dbRemoveTable, dbSendQuery, dbSendStatement

Examples

con <- dbConnect(RSQLite::SQLite(), ":memory:")

dbWriteTable(con, "mtcars", mtcars[1:10, ])
dbReadTable(con, "mtcars")

dbDisconnect(con)