sqlAppendTable: sqlAppendTable

In kineticadb/RKinetica: Kinetica DBI datasource

Description

Compose query to insert rows into a table

Usage

sqlAppendTable(con, table, values, row.names = NA, ...)

Arguments

con	A database connection.
table	Name of the table. Escaped with [dbQuoteIdentifier()].
values	A data frame. Factors will be converted to character vectors.
row.names	a flag with logical, character or NULL value
...	Other parameters passed on to methods. Character vectors will be escaped with [dbQuoteString()].

Details

'sqlAppendTable()' generates a single SQL string that inserts a data frame into an existing table. 'sqlAppendTableTemplate()' generates a template suitable for use with [dbBind()]. The default methods are ANSI SQL 99 compliant. These methods are mostly useful for backend implementers.

The 'row.names' argument must be passed explicitly in order to avoid a compatibility warning. The default will be changed in a later release.

See Also

Other SQL generation: sqlAppendTableTemplate

kineticadb/RKinetica documentation built on Sept. 29, 2020, 5:38 p.m.