dbReadTable: dbReadTable

In EXASOL/r-exasol: R Interface & SDK for the EXASOL Database

dbReadTable

Description

dbReadTable

Usage

## S4 method for signature 'EXAConnection,character'
dbReadTable(conn, name, schema = "", order_col = NA, limit = NA, ...)

Arguments

conn	An EXAConnection object.
name	A fully qualified table name in the form schema.table.
schema	Alternatively and with preference to 'name', a schema can be specified separately.
order_col	A string containing columns to have the result set ordered upon, e.g. "col1 desc, col2"
limit	A row limit to the result set. CAUTION: a limit without order clause is non-deterministic in EXASOL, i.e. subsequent runs of the same statement may deliver differing result sets.
...	Further arguments to be passed on to exa.readData.

Value

The result exa.readData, by default a data.frame containing the result set.

Functions

• dbReadTable,EXAConnection,character-method: Reads a DB table.

See Also

DBI::dbReadTable()

Other EXAConnection related objects: EXAConnection-class, dbBegin,EXAConnection-method, dbCommit,EXAConnection-method, dbConnect,EXADriver-method, dbCurrentSchema(), dbEnd(), dbExistsTable,EXAConnection,character-method, dbGetQuery,EXAConnection,character-method, dbListFields,EXAConnection,character-method, dbListTables,EXAConnection-method, dbRemoveTable,EXAConnection,character-method, dbRollback,EXAConnection-method, dbSendQuery,EXAConnection,character-method, dbWriteTable,EXAConnection,character,data.frame-method

Other DQL functions: dbClearResult,EXAResult-method, dbExistsTable,EXAConnection,character-method, dbGetQuery,EXAConnection,character-method, dbListFields,EXAConnection,character-method, dbListTables,EXAConnection-method, dbSendQuery,EXAConnection,character-method, fetch,EXAResult,numeric-method

EXASOL/r-exasol documentation built on Aug. 28, 2023, 2:32 a.m.