Connect to the CalCOFI PostgreSQL database (Admin only) - DEPRECATED

deprecated

This function is deprecated. For the public releases use cc_get_db (DuckDB over Parquet); for the multi-user PostgreSQL database (CTD QA/QC, database calcofi) use cc_pg_connect, which reads your role and password from ~/.pgpass instead of a password file.

Note that you must either be running this from the CalCOFI server or have a tunnelled SSH connection with a user account on the server and the password in a file located at "~/.calcofi_db_pass.txt".

Usage

cc_db_connect(path_pw = "~/.calcofi_db_pass.txt")

Arguments

path_pw

path to password file with one line containing the database password; default: "~/.calcofi_db_pass.txt"

Value

a DBI::dbConnect() object

Examples

if (FALSE) { # \dontrun{
con <- cc_db_connect()
DBI::dbListTables(con)
} # }