All functions

DBI-package

DBI: R Database Interface

DBIConnection-class

DBIConnection class

DBIDriver-class

DBIDriver class

DBIObject-class

DBIObject class

DBIResult-class

DBIResult class

SQL

SQL quoting

Table

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

dbBind

Bind values to a parameterized/prepared statement

dbClearResult

Clear a result set

dbColumnInfo

Information about result types

dbConnect

Create a connection to a DBMS

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

dbIsValid

Is this DBMS object still valid?

dbListConnections

List currently open connections

dbListFields

List field names of a remote table

dbListResults

A list of all pending results

dbListTables

List remote tables

dbQuoteIdentifier

Quote identifiers

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

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

Insert rows into a table

sqlCreateTable

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