Connect to choptank-db

Make sure you have

• installed the RPostgreSQL library with install.packages("RPostgreSQL").
• saved the database password as .pgpass in your working directory.
• connected to VPN or are using rstudio.sesync.org

library(RPostgreSQL)

Read in password if you have it saved in your working directory:

password <- scan(".pgpass", what="")

Or create a prompt to enter it in the Console window:

password <- readline(prompt="Enter password: ")

Create connection object called db. These guides will always use the name db for the connection object. All of the functions that send and receive information from the database will have this as the first argument.

db <- dbConnect(PostgreSQL(), 
                host = "sesync-postgis01.research.sesync.org",
                dbname = "choptank", 
                user = "palmergroup",
                password = password)

If you want to read a whole table from the database into your R environment, you can use dbReadTable().

samplingfeatures <- dbReadTable(db, c("odm2", "samplingfeatures"))

RS-DBI driver warning: (unrecognized PostgreSQL field type uuid (id:2950) in column 1)RS-DBI driver warning: (unrecognized PostgreSQL field type geometry (id:114457131) in column 7)

Disconnect at the end of your session

rr dbDisconnect(db)