sqlCreateTable: sqlCreateTable()

In kineticadb/RKinetica: Kinetica DBI datasource

Description

Customised version of the generic sqlCreateTable method (Kinetica DB uses TEMP keyword instead of TEMPORARY)

Usage

## S4 method for signature 'KineticaConnection'
sqlCreateTable(con, table, fields,
  row.names = NA, temporary = FALSE, ...)

Arguments

con	A database connection.
table	Name of the table. Escaped with [dbQuoteIdentifier()].
fields	Either a character vector or a data frame. A named character vector: Names are column names, values are types. Names are escaped with [dbQuoteIdentifier()]. Field types are unescaped. A data frame: field types are generated using [dbDataType()].
row.names	a flag with logical, character or NULL value
temporary	logical TRUE/FALSE for temporary/permanent table created
...	Other parameters passed on to methods.

See Also

Other KineticaConnection methods: dbAppendTable, dbCreateTable, dbDataType,KineticaConnection-method, dbDisconnect,KineticaConnection-method, dbExecute,KineticaConnection,character-method, dbExistsTable, dbGetInfo, dbGetQuery,KineticaConnection,character-method, dbIsValid, dbListFields, dbListObjects,KineticaConnection-method, dbListResults,KineticaConnection-method, dbListTables,KineticaConnection-method, dbReadTable, dbRemoveTable, dbSendQuery,KineticaConnection,character-method, dbSendStatement,KineticaConnection,character-method, dbWriteTable, show,KineticaDriver-method, transactions

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