| PostgreSQLConnection-class {RPostgreSQL} | R Documentation |
Class PostgreSQLConnection
Description
PostgreSQLConnection class.
Generators
The method dbConnect is the main generator.
Extends
Class "DBIConnection", directly.
Class "PostgreSQLObject", directly.
Class "DBIObject", by class "DBIConnection".
Class "dbObjectId", by class "PostgreSQLObject".
Methods
- coerce
signature(from = "PostgreSQLConnection", to = "PostgreSQLResult"): ...- dbBegin
signature(conn = "PostgreSQLConnection"): ...- dbCallProc
signature(conn = "PostgreSQLConnection"): ...- dbCommit
signature(conn = "PostgreSQLConnection"): ...- dbConnect
signature(drv = "PostgreSQLConnection"): ...- dbDisconnect
signature(conn = "PostgreSQLConnection"): ...- dbExistsTable
signature(conn = "PostgreSQLConnection", name = "character"): ...- dbGetException
signature(conn = "PostgreSQLConnection"): ...- dbGetInfo
signature(dbObj = "PostgreSQLConnection"): ...- dbGetQuery
signature(conn = "PostgreSQLConnection", statement = "character"): ...- dbListFields
signature(conn = "PostgreSQLConnection", name = "character"): ...- dbListResults
signature(conn = "PostgreSQLConnection"): ...- dbListTables
signature(conn = "PostgreSQLConnection"): ...- dbReadTable
signature(conn = "PostgreSQLConnection", name = "character"): ...- dbRemoveTable
signature(conn = "PostgreSQLConnection", name = "character"): ...- dbRollback
signature(conn = "PostgreSQLConnection"): ...- dbSendQuery
signature(conn = "PostgreSQLConnection", statement = "character"): ...- dbWriteTable
signature(conn = "PostgreSQLConnection", name = "character", value = "data.frame"): ...- summary
signature(object = "PostgreSQLConnection"): ...
References
See the Database Interface definition document
DBI.pdf in the base directory of this package
or https://developer.r-project.org/db/.
See Also
DBI base classes:
DBIObject-class
DBIDriver-class
DBIConnection-class
DBIResult-class
PostgreSQL classes:
PostgreSQLObject-class
PostgreSQLDriver-class
PostgreSQLConnection-class
PostgreSQLResult-class
Examples
## Not run:
drv <- dbDriver("PostgreSQL)
con <- dbConnect(drv, dbname = "template1")
## End(Not run)