R: DuckDB connection class

duckdb_connection-class {duckdb}

R Documentation

DuckDB connection class

Description

Usage

## 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, ..., arrow = FALSE)

## 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, ...)

Arguments

`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 `dbConnect()`.
`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
`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 `dbQuoteIdentifier()`.
`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?

[Package duckdb version 0.2.8 Index]