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.

dbWriteTable(<PqConnection>,<character>,<data.frame>) sqlData(<PqConnection>) dbAppendTable(<PqConnection>) dbReadTable(<PqConnection>,<character>) dbListTables(<PqConnection>) dbExistsTable(<PqConnection>,<character>) dbExistsTable(<PqConnection>,<Id>) dbRemoveTable(<PqConnection>,<character>) dbListFields(<PqConnection>,<character>) dbListFields(<PqConnection>,<Id>) dbListObjects(<PqConnection>)

Convenience functions for reading/writing DBMS tables

dbQuoteString(<PqConnection>,<character>) dbQuoteString(<PqConnection>,<SQL>) dbQuoteIdentifier(<PqConnection>,<character>) dbQuoteIdentifier(<PqConnection>,<SQL>) dbQuoteIdentifier(<PqConnection>,<Id>) dbUnquoteIdentifier(<PqConnection>,<SQL>) dbQuoteLiteral(<PqConnection>)

Quote postgres strings, identifiers, and literals

Queries and statements

Sending queries and executing statements.

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

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.

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