Skip to contents

Connect to postgres database

Source: R/fpr_db_conn.R
fpr_db_conn.Rd

Connect to postgres database

Usage

fpr_db_conn(
  db_var = Sys.getenv("PG_DB_SHARE"),
  host_var = Sys.getenv("PG_HOST_SHARE"),
  port_var = Sys.getenv("PG_PORT_SHARE"),
  user_var = Sys.getenv("PG_USER_SHARE"),
  password_var = Sys.getenv("PG_PASS_SHARE")
)

Arguments

db_var

Quoted character string value of database name.

host_var

Quoted character string value of host name.

port_var

Quoted character string value of port name.

user_var

Quoted character string value of user name.

password_var

Quoted character string value of password.

Value

DBI connection

See also

Other database postgres: fpr_db_query(), fpr_dbq_clip(), fpr_dbq_lscols(), fpr_dbq_lstables(), fpr_dbq_subset()

Examples

if (FALSE) {
conn <- fpr_db_conn()
}