Modern R Programming Cookbook

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.