duckdb_connection-class | R Documentation |
Implements DBIConnection.
## S4 method for signature 'duckdb_connection'
dbAppendTable(conn, name, value, ..., row.names = NULL)
## S4 method for signature 'duckdb_connection'
dbBegin(conn, ...)
## S4 method for signature 'duckdb_connection'
dbCommit(conn, ...)
## S4 method for signature 'duckdb_connection'
dbDataType(dbObj, obj, ...)
## S4 method for signature 'duckdb_connection,character'
dbExistsTable(conn, name, ...)
## S4 method for signature 'duckdb_connection'
dbGetInfo(dbObj, ...)
## S4 method for signature 'duckdb_connection'
dbIsValid(dbObj, ...)
## S4 method for signature 'duckdb_connection,character'
dbListFields(conn, name, ...)
## S4 method for signature 'duckdb_connection'
dbListTables(conn, ...)
## S4 method for signature 'duckdb_connection,ANY'
dbQuoteIdentifier(conn, x, ...)
## S4 method for signature 'duckdb_connection'
dbQuoteLiteral(conn, x, ...)
## S4 method for signature 'duckdb_connection,character'
dbRemoveTable(conn, name, ..., fail_if_missing = TRUE)
## S4 method for signature 'duckdb_connection'
dbRollback(conn, ...)
## S4 method for signature 'duckdb_connection,character'
dbSendQuery(conn, statement, params = NULL, ..., arrow = FALSE)
## S4 method for signature 'duckdb_connection,character,data.frame'
dbWriteTable(
conn,
name,
value,
row.names = FALSE,
overwrite = FALSE,
append = FALSE,
field.types = NULL,
temporary = FALSE,
...
)
## S4 method for signature 'duckdb_connection'
show(object)
conn |
A DBIConnection object, as returned by
|
name |
The table name, passed on to
|
value |
A data frame of values. The column names must be consistent with those in the target table in the database. |
... |
Other parameters passed on to methods. |
row.names |
Whether the row.names of the data.frame should be preserved |
dbObj |
A object inheriting from DBIDriver or DBIConnection |
obj |
An R object whose SQL type we want to determine. |
statement |
a character string containing SQL. |
params |
A list of bindings, named or unnamed. |
arrow |
Whether the query should be returned as an Arrow Table |
overwrite |
If a table with the given name already exists, should it be overwritten? |
append |
If a table with the given name already exists, just try to append the passed data to it |
field.types |
Override the auto-generated SQL types |
temporary |
Should the created table be temporary? |
object |
Any R object |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.