Redshift {RPostgres} | R Documentation |
Redshift driver/connection
Description
Redshift currently uses all the same methods as Postgres, but provides an extension point for future methods and downstream packages.
Usage
Redshift()
## S4 method for signature 'RedshiftDriver'
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"
)
Arguments
drv |
Should be set to |
dbname |
Database name. If |
host |
Host and port. If |
port |
Host and port. If |
password |
User name and password. If |
user |
User name and password. If |
service |
Name of service to connect as. If |
... |
Other name-value pairs that describe additional connection options as described at http://www.postgresql.org/docs/9.6/static/libpq-connect.html#LIBPQ-PARAMKEYWORDS |
bigint |
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. |
check_interrupts |
Should user interrupts be checked during the query execution (before
first row of data is available)? Setting to |
timezone |
Sets the timezone for the connection. The default is |