Connecting and disconnecting
Connecting to and disconnecting from a database.
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.
Transactions
Ensuring multiple statements are executed together, or not at all.
Misellaneous
Functions specific to Postgres