dbSendQuery-methods {RPostgreSQL} | R Documentation |
These methods are straight-forward implementations of the corresponding generic functions.
PostgreSQLConnection
object.
PostgreSQLResult
object.
See the Database Interface definition document
DBI.pdf
in the base directory of this package
or http://stat.bell-labs.com/RS-DBI.
PostgreSQL
,
dbDriver
,
dbConnect
,
fetch
,
dbCommit
,
dbGetInfo
,
dbReadTable
.
## Not run: drv <- dbDriver("PostgreSQL") con <- dbConnect(drv, "usr", "password", "dbname") res <- dbSendQuery(con, "SELECT * from sales") data <- fetch(res, n = -1) # alternatively, use dbGetQuery data <- dbGetQuery(con, "SELECT * from sales") ## End(Not run)