DuckDB connection class
Implements DBIConnection.
## S4 method for signature 'duckdb_connection' show(object) ## S4 method for signature 'duckdb_connection' dbIsValid(dbObj, ...) ## S4 method for signature 'duckdb_connection,character' dbSendQuery(conn, statement, params = NULL, ...) ## S4 method for signature 'duckdb_connection' dbDataType(dbObj, obj, ...) ## 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' dbListTables(conn, ...) ## S4 method for signature 'duckdb_connection,character' dbExistsTable(conn, name, ...) ## S4 method for signature 'duckdb_connection,character' dbListFields(conn, name, ...) ## S4 method for signature 'duckdb_connection,character' dbRemoveTable(conn, name, ...) ## S4 method for signature 'duckdb_connection' dbGetInfo(dbObj, ...) ## S4 method for signature 'duckdb_connection' dbBegin(conn, ...) ## S4 method for signature 'duckdb_connection' dbCommit(conn, ...) ## S4 method for signature 'duckdb_connection' dbRollback(conn, ...)
object |
Any R object |
dbObj |
An object inheriting from DBIObject, i.e. DBIDriver, DBIConnection, or a DBIResult |
... |
Other arguments to methods. |
conn |
A DBIConnection object, as returned by
|
statement |
a character string containing SQL. |
params |
A list of bindings, named or unnamed. |
obj |
An R object whose SQL type we want to determine. |
name |
A character string specifying the unquoted DBMS table name,
or the result of a call to |
value |
a data.frame (or coercible to data.frame). |
row.names |
Whether the row.names of the data.frame should be preserved |
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? |
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.