R Database Interface

---

Documentation for package ‘DBI’ version 1.2.2

• DESCRIPTION file.
• User guides, package vignettes and other documentation.
• Package NEWS.

Help Pages

DBI-package	DBI: R Database Interface
.SQL92Keywords	Keywords according to the SQL-92 standard
dbAppendTable	Insert rows into a table
dbAppendTableArrow	Insert rows into a table from an Arrow stream
dbBegin	Begin/commit/rollback SQL transactions
dbBind	Bind values to a parameterized/prepared statement
dbBindArrow	Bind values to a parameterized/prepared statement
dbBreak	Self-contained SQL transactions
dbCanConnect	Check if a connection to a DBMS can be established
dbClearResult	Clear a result set
dbColumnInfo	Information about result types
dbCommit	Begin/commit/rollback SQL transactions
dbConnect	Create a connection to a DBMS
dbCreateTable	Create a table in the database
dbCreateTableArrow	Create a table in the database based on an Arrow object
dbDataType	Determine the SQL data type of an object
dbDisconnect	Disconnect (close) a connection
dbExecute	Change database state
dbExistsTable	Does a table exist?
dbFetch	Fetch records from a previously executed query
dbFetchArrow	Fetch records from a previously executed query as an Arrow object
dbFetchArrowChunk	Fetch the next batch of records from a previously executed query as an Arrow object
dbGetConnectArgs	Get connection arguments
dbGetInfo	Get DBMS metadata
dbGetQuery	Retrieve results from a query
dbGetQueryArrow	Retrieve results from a query as an Arrow object
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
DBI	DBI: R Database Interface
DBIConnection-class	DBIConnection class
DBIConnector-class	DBIConnector class
DBIDriver-class	DBIDriver class
DBIObject-class	DBIObject class
DBIResult-class	DBIResult class
DBIResultArrow-class	DBIResultArrow class
DBIResultArrowDefault-class	DBIResultArrow class
dbIsReadOnly	Is this DBMS object read only?
dbIsValid	Is this DBMS object still valid?
dbListFields	List field names of a remote table
dbListObjects	List remote objects
dbListTables	List remote tables
dbQuoteIdentifier	Quote identifiers
dbQuoteLiteral	Quote literal values
dbQuoteString	Quote literal strings
dbReadTable	Read database tables as data frames
dbReadTableArrow	Read database tables as Arrow objects
dbRemoveTable	Remove a table from the database
dbRollback	Begin/commit/rollback SQL transactions
dbSendQuery	Execute a query on a given database connection
dbSendQueryArrow	Execute a query on a given database connection for retrieval via Arrow
dbSendStatement	Execute a data manipulation statement on a given database connection
dbUnquoteIdentifier	Unquote identifiers
dbWithTransaction	Self-contained SQL transactions
dbWriteTable	Copy data frames to database tables
dbWriteTableArrow	Copy Arrow objects to database tables
fetch	Fetch records from a previously executed query
Id	Refer to a table nested in a hierarchy (e.g. within a schema)
Id-class	Refer to a table nested in a hierarchy (e.g. within a schema)
rownames	Convert row names back and forth between columns
SQL	SQL quoting
SQL-class	SQL quoting
sqlAppendTable	Compose query to insert rows into a table
sqlAppendTableTemplate	Compose query to insert rows into a table
sqlColumnToRownames	Convert row names back and forth between columns
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
sqlRownamesToColumn	Convert row names back and forth between columns
transactions	Begin/commit/rollback SQL transactions