dbSendQuery-methods {RPostgreSQL}R Documentation

Execute a statement on a given database connection

Description

These methods are straight-forward implementations of the corresponding generic functions.

Methods

conn
an PostgreSQLConnection object.
statement
a character vector of length 1 with the SQL statement.
res
an PostgreSQLResult object.
...
additional parameters.

References

See the Database Interface definition document DBI.pdf in the base directory of this package or http://stat.bell-labs.com/RS-DBI.

See Also

PostgreSQL, dbDriver, dbConnect, fetch, dbCommit, dbGetInfo, dbReadTable.

Examples

## Not run: 
drv <- dbDriver("PostgreSQL")
con <- dbConnect(drv, "usr", "password", "dbname")
res <- dbSendQuery(con, "SELECT * from sales")
data <- fetch(res, n = -1)
## End(Not run)

[Package RPostgreSQL version 0.1-3 Index]