R Database Interface


[Up] [Top]

Documentation for package ‘DBI’ version 0.3.1

Help Pages

dbBegin Begin/commit/rollback SQL transactions
dbClearResult Clear a result set.
dbColumnInfo Information about result types.
dbCommit Begin/commit/rollback SQL transactions
dbConnect Create a connection to a DBMS.
dbDataType Determine the SQL data type of an object.
dbDataType-method Determine the SQL data type of an object.
dbDisconnect Disconnect (close) a connection
dbDriver Load and unload database drivers.
dbDriver-method Load and unload database drivers.
dbExistsTable Does a table exist?
dbFetch Fetch records from a previously executed query.
dbFetch-method 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.
dbGetQuery-method Send query, retrieve results and then clear result set.
dbGetRowCount The number of rows fetched so far.
dbGetRowCount-method The number of rows fetched so far.
dbGetRowsAffected The number of rows affected by data modifying query.
dbGetRowsAffected-method The number of rows affected by data modifying query.
dbGetStatement Get the statement associated with a result set
dbGetStatement-method Get the statement associated with a result set
dbHasCompleted Has the operation completed?
dbHasCompleted-method Has the operation completed?
dbiCheckCompliance Check a driver for compliance with DBI.
DBIConnection-class DBIConnection class.
DBIDriver-class DBIDriver class.
DBIObject-class DBIObject class.
DBIResult-class DBIResult class.
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 SQL quoting.
dbQuoteIdentifier-method SQL quoting.
dbQuoteString SQL quoting.
dbQuoteString-method SQL quoting.
dbReadTable Copy data frames to and from database tables.
dbRemoveTable Remove a table from the database.
dbRollback Begin/commit/rollback SQL transactions
dbSendQuery Execute a statement on a given database connection.
dbUnloadDriver Load and unload database drivers.
dbWriteTable Copy data frames to and from database tables.
fetch Fetch records from a previously executed query.
isSQLKeyword Make R identifiers into legal SQL identifiers.
isSQLKeyword-method Make R identifiers into legal SQL identifiers.
isSQLKeyword.default Make R identifiers into legal SQL identifiers.
make.db.names Make R identifiers into legal SQL identifiers.
make.db.names-method Make R identifiers into legal SQL identifiers.
make.db.names.default Make R identifiers into legal SQL identifiers.
show-method SQL quoting.
SQL SQL quoting.
SQL-class SQL quoting.
SQLKeywords Make R identifiers into legal SQL identifiers.
SQLKeywords-method Make R identifiers into legal SQL identifiers.
transactions Begin/commit/rollback SQL transactions