setupPostgreSQL {rocker}

Setup database driver and define connection parameters for PostgreSQL using RPostgres package. Wrapper for setupDriver() function.

Description

Setup database driver and define connection parameters for PostgreSQL using RPostgres package. Wrapper for setupDriver() function.

Usage

setupPostgreSQL(
  db,
  host = "127.0.0.1",
  port = "5432",
  dbname = "mydb",
  user = "postgres",
  password = "password",
  protect = c("password", "user"),
  ...
)

Arguments

db

rocker object

host

Host name or IP number

port

Port number

dbname

Database name

user

User name

password

Password

protect

Parameters to be hidden

...

Optional, additional suitable parameters passed to DBI::dbConnect()

Value

Invisible self

See Also

Other rocker-S3-functions: appendTable(), begin(), canConnect(), clearResult(), columnInfo(), commit(), connect(), createTable(), disconnect(), execute(), existsTable(), fetch(), getInfoCon(), getInfoDrv(), getInfoRes(), getQuery(), getRowCount(), getRowsAffected(), getStatement(), hasCompleted(), isValidCon(), isValidDrv(), isValidRes(), listFields(), listObjects(), listTables(), readTable(), removeTable(), rocker-README, rocker-S3-functions, rocker-package, rollback(), sendQuery(), sendStatement(), setupDriver(), setupMariaDB(), setupSQLite(), unloadDriver(), validateCon(), writeTable()

Examples

db <- rocker::newDB()
rocker::setupPostgreSQL(
  db,
  host = "127.0.0.1", port = "5432", dbname = "mydb",
  user = "postgres", password = "password"
)
rocker::unloadDriver(db)