Library for connection into PostgreSQL database.
Available on the CRAN.

  1. Installation:
     
    > install.packages("RPostgreSQL") 
    also installing the dependency ‘DBI’ 
    
    trying URL 'https://cran.rstudio.com/bin/windows/contrib/3.2/DBI_0.3.1.zip' Content type 'application/zip' length 162324 bytes (158 KB) downloaded 158 KB 
    
    trying URL 'https://cran.rstudio.com/bin/windows/contrib/3.2/RPostgreSQL_0.4.zip' 
    
    Content type 'application/zip' length 438546 bytes (428 KB) downloaded 428 KB 
    
    package ‘DBI’ successfully unpacked and MD5 sums checked 
    package ‘RPostgreSQL’ successfully unpacked and MD5 sums checked 
    
    The downloaded binary packages are in 
              C:\Users\TestUser\AppData\Local\Temp\Rtmp0ESDDq\downloaded_packages 
    
  2. Loading:
    > library(RPostgreSQL)
    Loading required package: DBI
    
  3. Usage:
    > drv<-dbDriver("PostgreSQL")
    > pgconn<-dbConnect(drv, dbname="mydb", host="172.xx.xx.xx", port=5432, user="myuser", password="mypassw")