PostgreSQL access


[Package List] [Top]
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