All functions

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

Postgres driver

RPostgres-package

RPostgres: 'Rcpp' Interface to 'PostgreSQL'

Redshift() dbConnect(<RedshiftDriver>)

Redshift driver/connection

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

Execute a SQL statement on a database connection

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

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

Transaction management.

postgresHasDefault() postgresDefault()

Check if default database is available.

postgresWaitForNotify()

Wait for and return any notifications that return within timeout

dbQuoteString(<PqConnection>,<character>) dbQuoteString(<PqConnection>,<SQL>) dbQuoteIdentifier(<PqConnection>,<character>) dbQuoteIdentifier(<PqConnection>,<SQL>) dbQuoteIdentifier(<PqConnection>,<Id>) dbUnquoteIdentifier(<PqConnection>,<SQL>) dbQuoteLiteral(<PqConnection>,<logical>) dbQuoteLiteral(<PqConnection>,<integer>) dbQuoteLiteral(<PqConnection>,<numeric>) dbQuoteLiteral(<PqConnection>,<factor>) dbQuoteLiteral(<PqConnection>,<Date>) dbQuoteLiteral(<PqConnection>,<POSIXt>) dbQuoteLiteral(<PqConnection>,<difftime>) dbQuoteLiteral(<PqConnection>,<list>) dbQuoteLiteral(<PqConnection>,<blob>) dbQuoteLiteral(<PqConnection>,<character>)

Quote postgres strings, identifiers, and literals