Modern R Programming Cookbook

How it works...

Every database software has its own driver that helps it to connect with the database.

Let's take a look at the following steps and see how they work:

1. The first step to connect with the PostgreSQL database server is to call the driver and then connect with it. The following line of R code is used to activate the PostgreSQL database driver into R session:

        databaseDriver <- dbDriver("PostgreSQL")

2. Once the driver is activated, the next task is to create a connection string with the database server and R session with the following code:

        con2DB <- dbConnect(databaseDriver, dbname = "postgres",  host           = "localhost", port = 5432, user = "postgres", password =         p_word)

3. The dbConnect() function takes the driver object as the ...