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

deprecated

This function is deprecated. Please use cc_get_db instead for connecting to the new DuckDB-based database.

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".

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)
} # }