DBI-package DBI: R Database Interface DBIConnection-class DBIConnection class DBIDriver-class DBIDriver class DBIObject-class DBIObject class DBIResult-class DBIResult class Id-class 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 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 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 Self-contained SQL transactions dbWriteTable Copy data frames to database tables make.db.names Make R identifiers into legal SQL identifiers rownames Convert row names back and forth between columns sqlAppendTable 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 transactions Begin/commit/rollback SQL transactions