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"): ...
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 http://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)

[Package RPostgreSQL version 0.1-4 Index]