Interacting with the PostgreSQL database from R

A dataset is not only used for storing information, but, usually, you also need to interact with it to find out useful information. Whenever the dataset has been stored in a database, the interactive process is more efficient in terms of memory and processing time. In this recipe, you will interact with a data table that has already been stored in a database in the PostgreSQL database server.

Getting ready

Let's consider that you have created a database postgres and stored a dataset in it with the table name airlineDB. To get access to the database server, you will require the username and password for the owner of the database. Here is the username and password for the database:

• Username: postgres
• Password: postres123

The dataset that has been stored under the postgres database is the airlineDB table, and it contains the following columns:

• YEAR (integer)
• QUARTER (integer)
• MONTH (integer)
• ORIGIN (character, 3)
• DEST (character, 3)
• DEP_DELAY (numeric,...