All functions

DBI-package

DBI: R Database Interface

DBIConnection-class

DBIConnection class

DBIDriver-class

DBIDriver class

DBIObject-class

DBIObject class

DBIResult-class

DBIResult class

Id()

Refer to a table nested in a hierarchy (e.g. within a schema)

SQL()

SQL quoting

dbAppendTable()

Insert rows into a table

dbBind()

Bind values to a parameterized/prepared statement

dbCanConnect()

Check if a connection to a DBMS can be established

dbClearResult()

Clear a result set

dbColumnInfo()

Information about result types

dbConnect()

Create a connection to a DBMS

dbCreateTable()

Create a table in the database

dbDataType()

Determine the SQL data type of an object

dbDisconnect()

Disconnect (close) a connection

dbDriver() dbUnloadDriver()

Load and unload database drivers

dbExecute()

Execute an update statement, query number of rows affected, and then close result set

dbExistsTable()

Does a table exist?

dbFetch() fetch()

Fetch records from a previously executed query

dbGetException()

Get DBMS exceptions

dbGetInfo()

Get DBMS metadata

dbGetQuery()

Send query, retrieve results and then clear result set

dbGetRowCount()

The number of rows fetched so far

dbGetRowsAffected()

The number of rows affected

dbGetStatement()

Get the statement associated with a result set

dbHasCompleted()

Completion status

dbIsReadOnly()

Is this DBMS object read only?

dbIsValid()

Is this DBMS object still valid?

dbListConnections()

List currently open connections

dbListFields()

List field names of a remote table

dbListObjects()

List remote objects

dbListResults()

A list of all pending results

dbListTables()

List remote tables

dbQuoteIdentifier()

Quote identifiers

dbQuoteLiteral()

Quote literal values

dbQuoteString()

Quote literal strings

dbReadTable()

Copy data frames from database tables

dbRemoveTable()

Remove a table from the database

dbSendQuery()

Execute a query on a given database connection

dbSendStatement()

Execute a data manipulation statement on a given database connection

dbUnquoteIdentifier()

Unquote identifiers

dbWithTransaction() dbBreak()

Self-contained SQL transactions

dbWriteTable()

Copy data frames to database tables

make.db.names() make.db.names.default() isSQLKeyword() isSQLKeyword.default()

Make R identifiers into legal SQL identifiers

sqlRownamesToColumn() sqlColumnToRownames()

Convert row names back and forth between columns

sqlAppendTable() sqlAppendTableTemplate()

Compose query to insert rows into a table

sqlCreateTable()

Compose query to create a simple table

sqlData()

Convert a data frame into form suitable for upload to an SQL database

sqlInterpolate()

Safely interpolate values into an SQL string

dbBegin() dbCommit() dbRollback()

Begin/commit/rollback SQL transactions