Connect to the CalCOFI PostgreSQL database (Admin only)

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) {
con <- cc_db_connect()
DBI::dbListTables(con)
}