bind.db.proxy | Bind a proxy object to a PostgreSQL table |
db.clear.result | Send commands to the PostgreSQL back end |
db.connect | Open and manage database connection |
db.disconnect | Open and manage database connection |
db.execute | Send commands to the PostgreSQL back end |
db.fetch.result | Read query results into a data frame |
db.ls | list database tables |
db.read.column | Read query results into a data frame |
db.read.table | Read query results into a data frame |
db.result.column.names | Information about the result buffer |
db.result.column.type | Information about the result buffer |
db.result.columns | Information about the result buffer |
db.result.get.value | Fetch a value from returned tuples |
db.result.rows | Information about the result buffer |
db.rm | list database tables |
db.toggle.echo | Send commands to the PostgreSQL back end |
db.write.table | Write an R data frame into a PostgreSQL table |
Execute queries | Send commands to the PostgreSQL back end |
List database tables | list database tables |
Manage connections | Open and manage database connection |
Proxy interface | Bind a proxy object to a PostgreSQL table |
psql | Run the PostgreSQL monitor |
Read from database | Read query results into a data frame |
Result attributes | Information about the result buffer |
sql.insert | Append data to a PostgreSQL table |
sql.select | Format and optionally execute an SQL select query |
Type conversions | Conversion between R and PostgreSQL data types |
Utilities | RPgSQL utility functions |