PostgreSQL is an open source object relational database management system. PostgreSQL runs on most of the operating systems such as Linux, UNIX, and Windows. It supports text, image, sound, and video data sources. It supports programming technologies such as C, C++, Java, Python, Ruby, and Tcl.
The following are the features of PostgreSQL:
Complex SQL queries
Fully ACID complaint
SQL subselects
We need to have installed the following prerequisites for using PostgreSQL in R:
Installing Postgre SQL
Installing RPostgre SQL
In this section, we will learn about installing PostgreSQL.
The given commands will be followed for the installation of PostgreSQL:
// updating the packages list Sudo apt-get update // installing postgresql sudo apt-get install postgresql postgresql-contrib // creating postgresql user su – postgres createuser