dbWriteTable: dbWriteTable

In EXASOL/r-exasol: R Interface & SDK for the EXASOL Database

dbWriteTable

Description

dbWriteTable

Usage

## S4 method for signature 'EXAConnection,character,data.frame'
dbWriteTable(
  conn,
  name,
  value,
  schema = "",
  field_types,
  overwrite = FALSE,
  writeCols = NA,
  ...
)

Arguments

conn	An EXAConnection object.
name	A fully qualified table name (schema.table). Alternatively the schema can be given via the parameter 'schema' (see below).
value	A data.frame containing data.
schema	A schema identifier.
field_types	A character vector containing the column data types, in the form of c("varchar(20)","int"). If missing, the column types of the data.frame are being converted and used.
overwrite	A logical indicating if existing data shall be overwritten. Default is 'FALSE', i.e. new data is appended to the DB table.
writeCols	A logical or a character vector containing the cols of the DB table to be written into, in the form of c("col1","col4","col3"). If set to TRUE, then the column names of the data.frame are used. If FALSE, NA, or missing, no write columns are defined and columns are matched by column order. Default is NA. Useful to change if the DB table contains more columns than the data.frame, or if the column order differs.
...	Additional parameters to be passed on to exa.writeData.

Value

A logical indicating success.

Functions

• dbWriteTable,EXAConnection,character,data.frame-method: Writes a data.frame into a table. If the table does not exist, it is created.

See Also

DBI::dbWriteTable()

Other EXAConnection related objects: EXAConnection-class, dbBegin,EXAConnection-method, dbCommit,EXAConnection-method, dbConnect,EXADriver-method, dbCurrentSchema(), dbEnd(), dbExistsTable,EXAConnection,character-method, dbGetQuery,EXAConnection,character-method, dbListFields,EXAConnection,character-method, dbListTables,EXAConnection-method, dbReadTable,EXAConnection,character-method, dbRemoveTable,EXAConnection,character-method, dbRollback,EXAConnection-method, dbSendQuery,EXAConnection,character-method

Other DML functions: dbRemoveTable,EXAConnection,character-method

EXASOL/r-exasol documentation built on Dec. 4, 2024, 10:22 p.m.