DBI::dbConnect() establishes a connection to a database.
drv = RPostgres::Postgres() to connect to a SQL database
using the RPostgres package.
Manually disconnecting a connection is not necessary with RPostgres, but still recommended; if you delete the object containing the connection, it will be automatically disconnected during the next GC with a warning.
Postgres() # S4 method for PqDriver dbConnect( drv, dbname = NULL, host = NULL, port = NULL, password = NULL, user = NULL, service = NULL, ..., bigint = c("integer64", "integer", "numeric", "character"), check_interrupts = FALSE, timezone = "UTC", timezone_out = NULL ) # S4 method for PqConnection dbDisconnect(conn, ...)
Should be set to
Database name. If
Host and port. If
User name and password. If
Name of service to connect as. If
Other name-value pairs that describe additional connection options as described at https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-PARAMKEYWORDS
The R type that 64-bit integer types should be mapped to, default is bit64::integer64, which allows the full range of 64 bit integers.
Should user interrupts be checked during the query execution (before
first row of data is available)? Setting to
Sets the timezone for the connection. The default is
The time zone returned to R, defaults to
Connection to disconnect.