columnInfo: Information on query result columns.

In rocker: Database Interface Class

Information on query result columns.

Description

Information on query result columns.

Usage

columnInfo(db, ...)

Arguments

db	rocker object
...	Optional, additional suitable parameters passed to DBI::dbColumnInfo()

Value

Information table

See Also

Other rocker-S3-functions: appendTable(), begin(), canConnect(), clearResult(), commit(), connect(), createTable(), disconnect(), execute(), existsTable(), fetch(), getInfoCon(), getInfoDrv(), getInfoRes(), getQuery(), getRowCount(), getRowsAffected(), getStatement(), hasCompleted(), isValidCon(), isValidDrv(), isValidRes(), listFields(), listObjects(), listTables(), readTable(), removeTable(), rocker-README, rocker-S3-functions, rocker-package, rollback(), sendQuery(), sendStatement(), setupDriver(), setupMariaDB(), setupPostgreSQL(), setupSQLite(), unloadDriver(), validateCon(), writeTable()

Examples

db <- rocker::newDB()
rocker::setupSQLite(db)
rocker::connect(db)
rocker::writeTable(db, "mtcars", mtcars)
rocker::sendQuery(db, "SELECT * FROM mtcars;")
rocker::columnInfo(db)
rocker::clearResult(db)
rocker::disconnect(db)
rocker::unloadDriver(db)

rocker documentation built on Aug. 21, 2022, 1:06 a.m.