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 |