Connecting and disconnecting

Connecting to and disconnecting from a database.

Postgres() dbConnect(<PqDriver>) dbDisconnect(<PqConnection>)

Postgres driver

Redshift() dbConnect(<RedshiftDriver>)

Redshift driver/connection

Tables

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>)

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>)

Quote postgres strings, identifiers, and literals

Queries and statements

Sending queries and executing statements.

dbBind(<PqResult>) dbClearResult(<PqResult>) dbFetch(<PqResult>) dbHasCompleted(<PqResult>) dbSendQuery(<PqConnection>)

Execute a SQL statement on a database connection

Transactions

Ensuring multiple statements are executed together, or not at all.

dbBegin(<PqConnection>) dbCommit(<PqConnection>) dbRollback(<PqConnection>)

Transaction management.

postgresIsTransacting()

Return whether a transaction is ongoing

Misellaneous

Functions specific to Postgres

RPostgres-package

RPostgres: Rcpp Interface to PostgreSQL

postgresHasDefault() postgresDefault()

Check if default database is available.

postgresWaitForNotify()

Wait for and return any notifications that return within timeout