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)

[Package RPostgreSQL version 0.7-6 Index]