R Interface to the 'PostgreSQL' Database System

Database interface and 'PostgreSQL' driver for 'R'. This package provides a Database Interface 'DBI' compliant driver for 'R' to access 'PostgreSQL' database systems. In order to build and install this package from source, 'PostgreSQL' itself must be present your system to provide 'PostgreSQL' functionality via its libraries and header files. These files are provided as 'postgresql-devel' package under some Linux distributions. On 'macOS' and 'Microsoft Windows' system the attached 'libpq' library source will be used.


Reference manual

It appears you don't have a PDF plugin for this browser. You can click here to download the reference manual.

install.packages("RPostgreSQL")

0.7-8 by Tomoaki Nishiyama, 2 years ago


https://github.com/tomoakin/RPostgreSQL, https://cran.r-project.org/package=DBI, https://www.postgresql.org


Browse source code at https://github.com/cran/RPostgreSQL


Authors: Joe Conway [aut] , Dirk Eddelbuettel [aut] , Tomoaki Nishiyama [aut, cre] , Sameer Kumar Prayaga [aut] (during 2008) , Neil Tiffin [aut]


Documentation:   PDF Manual  


GPL-3 | file LICENSE license


Depends on methods, DBI


Imported by RuHere, birdscanR, clintrialx, lucas, obm, occCite, sejmRP.

Depended on by BIEN, OpenRange, rpostgis.

Suggested by NetSimR, ProjectTemplate, dbplyr, dbx, dittodb, geoflow, hyd1d, nngeo, rdataretriever, sf, shiny.telemetry, spacetime, sqldf.


See at CRAN