db_insert: Insert rows into a database table

In daroczig/dbr: Convenient Database Connections and Queries

Description

Insert rows into a database table

Usage

db_insert(df, table, db, ...)

Arguments

df	data.frame
table	character vector of an optional schema and table name
db	database object returned by db_connect
...	further parameters passed to dbWriteTable, eg to modify row.names or append (depends on driver)

See Also

RMySQL::dbWriteTable, RPostgreSQL::dbReadTable-methods

db_append

Examples

## Not run: 
options('db_config_path' = system.file('example_db_config.yaml', package = 'dbr'))
db_insert(mtcars, 'mtcars', 'sqlite')
db_append(mtcars, c('dm', 'mtcars'), 'sqlite')

## End(Not run)

daroczig/dbr documentation built on June 12, 2020, 2:47 p.m.