Connecting to and disconnecting from a database.
Postgres() dbConnect(<PqDriver>) dbDisconnect(<PqConnection>)
Postgres()
dbConnect(<PqDriver>)
dbDisconnect(<PqConnection>)
Postgres driver
Redshift() dbConnect(<RedshiftDriver>)
Redshift()
dbConnect(<RedshiftDriver>)
Redshift driver/connection
Reading and writing entire tables.
dbAppendTable(<PqConnection>) dbExistsTable(<PqConnection>,<Id>) dbExistsTable(<PqConnection>,<character>) dbListFields(<PqConnection>,<Id>) dbListFields(<PqConnection>,<character>) dbListObjects(<PqConnection>) dbListTables(<PqConnection>) dbReadTable(<PqConnection>,<character>) dbRemoveTable(<PqConnection>,<character>) dbWriteTable(<PqConnection>,<character>,<data.frame>) sqlData(<PqConnection>)
dbAppendTable(<PqConnection>)
dbExistsTable(<PqConnection>,<Id>)
dbExistsTable(<PqConnection>,<character>)
dbListFields(<PqConnection>,<Id>)
dbListFields(<PqConnection>,<character>)
dbListObjects(<PqConnection>)
dbListTables(<PqConnection>)
dbReadTable(<PqConnection>,<character>)
dbRemoveTable(<PqConnection>,<character>)
dbWriteTable(<PqConnection>,<character>,<data.frame>)
sqlData(<PqConnection>)
Convenience functions for reading/writing DBMS tables
dbQuoteIdentifier(<PqConnection>,<Id>) dbQuoteIdentifier(<PqConnection>,<SQL>) dbQuoteIdentifier(<PqConnection>,<character>) dbQuoteLiteral(<PqConnection>) dbQuoteString(<PqConnection>,<SQL>) dbQuoteString(<PqConnection>,<character>) dbUnquoteIdentifier(<PqConnection>,<SQL>)
dbQuoteIdentifier(<PqConnection>,<Id>)
dbQuoteIdentifier(<PqConnection>,<SQL>)
dbQuoteIdentifier(<PqConnection>,<character>)
dbQuoteLiteral(<PqConnection>)
dbQuoteString(<PqConnection>,<SQL>)
dbQuoteString(<PqConnection>,<character>)
dbUnquoteIdentifier(<PqConnection>,<SQL>)
Quote postgres strings, identifiers, and literals
Sending queries and executing statements.
dbBind(<PqResult>) dbClearResult(<PqResult>) dbFetch(<PqResult>) dbHasCompleted(<PqResult>) dbSendQuery(<PqConnection>)
dbBind(<PqResult>)
dbClearResult(<PqResult>)
dbFetch(<PqResult>)
dbHasCompleted(<PqResult>)
dbSendQuery(<PqConnection>)
Execute a SQL statement on a database connection
Ensuring multiple statements are executed together, or not at all.
dbBegin(<PqConnection>) dbCommit(<PqConnection>) dbRollback(<PqConnection>)
dbBegin(<PqConnection>)
dbCommit(<PqConnection>)
dbRollback(<PqConnection>)
Transaction management.
postgresIsTransacting()
Return whether a transaction is ongoing
Functions specific to Postgres
RPostgres RPostgres-package
RPostgres
RPostgres-package
RPostgres: Rcpp Interface to PostgreSQL
postgresHasDefault() postgresDefault()
postgresHasDefault()
postgresDefault()
Check if default database is available.
postgresWaitForNotify()
Wait for and return any notifications that return within timeout