dbConnect-methods

0th

Percentile

Create a connection object to an PostgreSQL DBMS

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

Keywords
methods, interface, database
Methods

drv

an object of class PostgreSQLDriver, or the character string "PostgreSQL" or an PostgreSQLConnection.

conn

an PostgreSQLConnection object as produced by dbConnect.

host

Name or the numeric IPaddress of the host to connect to. If address is specified, it should be in the standard IPv4 address format, e.g., 172.28.40.9 or if your machine supports IPv6, you can also use those addresses. The default is to connect to localhost by a UNIX domain socket.

dbname

The database name. Defaults to "", which is interpreted as PostgreSQL default.

user

PostgreSQL user name to connect as. Defaults to be the same as the operating system name of the user running the application.

password

Password to be used if the server demands password authentication.

port

Port number to connect to at the server host.

tty

Ignored (formerly, this specified where to send server debug output).

options

Command-line options to be sent to the server.

forceISOdate

logical if the communication of date (time stamp) from PostgreSQL is forced to ISO style at conection.

Side Effects

A connection between R/S-Plus and an PostgreSQL server is established. The current implementation supports up to 100 simultaneous connections.

References

See the Database Interface definition document DBI.pdf in the base directory of this package or https://cran.r-project.org/package=DBI.

See Also

PostgreSQL, dbConnect, dbSendQuery, dbGetQuery, fetch, dbCommit, dbGetInfo, dbReadTable.

Aliases
  • dbDisconnect-methods
  • dbConnect-methods
  • dbDisconnect,PostgreSQLConnection-method
  • dbConnect,PostgreSQLDriver-method
  • dbConnect,PostgreSQLConnection-method
  • dbConnect,character-method
Examples

Documentation reproduced from package RPostgreSQL, version 0.6-2, License: GPL-2 | file LICENSE

Community examples

Looks like there are no examples yet.