Implements DBIConnection.
# S4 method for duckdb_connection
dbAppendTable(conn, name, value, ..., row.names = NULL)# S4 method for duckdb_connection
dbBegin(conn, ...)
# S4 method for duckdb_connection
dbCommit(conn, ...)
# S4 method for duckdb_connection
dbDataType(dbObj, obj, ...)
# S4 method for duckdb_connection,character
dbExistsTable(conn, name, ...)
# S4 method for duckdb_connection
dbGetInfo(dbObj, ...)
# S4 method for duckdb_connection
dbIsValid(dbObj, ...)
# S4 method for duckdb_connection,character
dbListFields(conn, name, ...)
# S4 method for duckdb_connection
dbListTables(conn, ...)
# S4 method for duckdb_connection,ANY
dbQuoteIdentifier(conn, x, ...)
# S4 method for duckdb_connection
dbQuoteLiteral(conn, x, ...)
# S4 method for duckdb_connection,character
dbRemoveTable(conn, name, ..., fail_if_missing = TRUE)
# S4 method for duckdb_connection
dbRollback(conn, ...)
# S4 method for duckdb_connection,character
dbSendQuery(conn, statement, params = NULL, ..., arrow = FALSE)
# S4 method for duckdb_connection,character,data.frame
dbWriteTable(
conn,
name,
value,
...,
row.names = FALSE,
overwrite = FALSE,
append = FALSE,
field.types = NULL,
temporary = FALSE
)
# S4 method for duckdb_connection
show(object)
A DBIConnection object, as returned by
dbConnect()
.
The table name, passed on to dbQuoteIdentifier()
. Options are:
a character string with the unquoted DBMS table name,
e.g. "table_name"
,
a call to Id()
with components to the fully qualified table name,
e.g. Id(schema = "my_schema", table = "table_name")
a call to SQL()
with the quoted and fully qualified table name
given verbatim, e.g. SQL('"my_schema"."table_name"')
A data.frame (or coercible to data.frame).
Other parameters passed on to methods.
Whether the row.names of the data.frame should be preserved
A object inheriting from DBIDriver or DBIConnection
An R object whose SQL type we want to determine.
a character string containing SQL.
For dbBind()
, a list of values, named or unnamed,
or a data frame, with one element/column per query parameter.
For dbBindArrow()
, values as a nanoarrow stream,
with one column per query parameter.
Whether the query should be returned as an Arrow Table
If a table with the given name already exists, should it be overwritten?
If a table with the given name already exists, just try to append the passed data to it
Override the auto-generated SQL types
Should the created table be temporary?
Any R object