Man pages for DBI
R Database Interface

ANSIA dummy DBI connector that simulates ANSI-SQL compliance
dbBindBind values to a parameterized/prepared statement
dbCallProcCall an SQL stored procedure
dbClearResultClear a result set
dbColumnInfoInformation about result types
dbConnectCreate a connection to a DBMS
dbDataTypeDetermine the SQL data type of an object
dbDisconnectDisconnect (close) a connection
dbDriverLoad and unload database drivers
dbExecuteExecute an update statement, query number of rows affected,...
dbExistsTableDoes a table exist?
dbFetchFetch records from a previously executed query
dbGetDBIVersionDetermine the current version of the package.
dbGetExceptionGet DBMS exceptions
dbGetInfoGet DBMS metadata
dbGetQuerySend query, retrieve results and then clear result set
dbGetRowCountThe number of rows fetched so far
dbGetRowsAffectedThe number of rows affected
dbGetStatementGet the statement associated with a result set
dbHasCompletedCompletion status
DBIConnection-classDBIConnection class
DBIDriver-classDBIDriver class
DBIObject-classDBIObject class
DBI-packageDBI: R Database Interface
DBIResult-classDBIResult class
dbIsValidIs this DBMS object still valid?
dbListConnectionsList currently open connections
dbListFieldsList field names of a remote table
dbListResultsA list of all pending results
dbListTablesList remote tables
dbQuoteIdentifierQuote identifiers
dbQuoteStringQuote literal strings
dbReadTableCopy data frames from database tables
dbRemoveTableRemove a table from the database
dbSendQueryExecute a query on a given database connection
dbSendStatementExecute a data manipulation statement on a given database...
dbSetDataMappingsSet data mappings between an DBMS and R.
dbWithTransactionSelf-contained SQL transactions
dbWriteTableCopy data frames to database tables
hidden_aliasesInternal page for hidden aliases
make.db.namesMake R identifiers into legal SQL identifiers
print.list.pairsPrint a list of pairs.
rownamesConvert row names back and forth between columns
SQLSQL quoting
sqlAppendTableInsert rows into a table
sqlCreateTableCreate a simple table
sqlDataConvert a data frame into form suitable for upload to an SQL...
sqlInterpolateSafely interpolate values into an SQL string
sqlParseVariablesParse interpolated variables from SQL.
TableRefer to a table nested in a hierarchy (e.g. within a schema)
transactionsBegin/commit/rollback SQL transactions
DBI documentation built on June 20, 2017, 9:13 a.m.