duckdb_result-class {duckdb}R Documentation

DuckDB Result Set

Description

Methods for accessing result sets for queries on DuckDB connections. Implements DBIResult.

Usage

## S4 method for signature 'duckdb_result'
show(object)

## S4 method for signature 'duckdb_result'
dbClearResult(res, ...)

duckdb_fetch_arrow(res)

## S4 method for signature 'duckdb_result'
dbFetch(res, n = -1, ...)

## S4 method for signature 'duckdb_result'
dbHasCompleted(res, ...)

## S4 method for signature 'duckdb_result'
dbGetInfo(dbObj, ...)

## S4 method for signature 'duckdb_result'
dbIsValid(dbObj, ...)

## S4 method for signature 'duckdb_result'
dbGetStatement(res, ...)

## S4 method for signature 'duckdb_result'
dbColumnInfo(res, ...)

## S4 method for signature 'duckdb_result'
dbGetRowCount(res, ...)

## S4 method for signature 'duckdb_result'
dbGetRowsAffected(res, ...)

## S4 method for signature 'duckdb_result'
dbBind(res, params, ...)

Arguments

object

Any R object

res

Query result to be converted to an Arrow Table

...

Other arguments passed on to methods.

n

maximum number of records to retrieve per fetch. Use n = -1 or n = Inf to retrieve all pending records. Some implementations may recognize other special values.

dbObj

An object inheriting from DBIObject, i.e. DBIDriver, DBIConnection, or a DBIResult

params

A list of bindings, named or unnamed.

[Package duckdb version 0.2.8 Index]