Man pages for rstats-db/DBI
R Database Interface
| ANSI | A dummy DBI connector that simulates ANSI-SQL compliance |
| dbAppendTable | Insert rows into a table |
| dbAppendTableArrow | Insert rows into a table from an Arrow stream |
| dbBind | Bind values to a parameterized/prepared statement |
| dbCallProc | Call an SQL stored procedure |
| 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 |
| 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 |
| dbDriver | Load and unload database drivers |
| 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... |
| dbFetchArrowChunk | Fetch the next batch of records from a previously executed... |
| dbGetConnectArgs | Get connection arguments |
| dbGetDBIVersion | Determine the current version of the package. |
| dbGetException | Get DBMS exceptions |
| 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 |
| DBIConnection-class | DBIConnection class |
| DBIConnector-class | DBIConnector class |
| DBIDriver-class | DBIDriver class |
| DBIObject-class | DBIObject class |
| DBI-package | DBI: R Database Interface |
| DBIResultArrow-class | DBIResultArrow class |
| DBIResult-class | DBIResult class |
| 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 | Read database tables as data frames |
| dbReadTableArrow | Read database tables as Arrow objects |
| dbRemoveTable | Remove a table from the database |
| dbSendQuery | Execute a query on a given database connection |
| dbSendQueryArrow | Execute a query on a given database connection for retrieval... |
| dbSendStatement | Execute a data manipulation statement on a given database... |
| dbSetDataMappings | Set data mappings between an DBMS and R. |
| dbUnquoteIdentifier | Unquote identifiers |
| dbWithTransaction | Self-contained SQL transactions |
| dbWriteTable | Copy data frames to database tables |
| dbWriteTableArrow | Copy Arrow objects to database tables |
| dot-SQL92Keywords | Keywords according to the SQL-92 standard |
| hidden_aliases | Internal page for hidden aliases |
| Id | Refer to a table nested in a hierarchy (e.g. within a schema) |
| make.db.names | Make R identifiers into legal SQL identifiers |
| rownames | Convert row names back and forth between columns |
| SQL | SQL quoting |
| 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... |
| sqlInterpolate | Safely interpolate values into an SQL string |
| sqlParseVariables | Parse interpolated variables from SQL. |
| transactions | Begin/commit/rollback SQL transactions |
