RPostgreSQL provides an interface between GNU R and the PostgreSQL database system. RPostgreSQL uses the standard DBI interface which is also used by the similar packages ROracle, RMySQL and RSQLite.

Highlights include:

  • Implements all the DBI features
  • Added support for transaction management
  • Added type mapping for dates & timestamps

RPostgreSQL was initially written by Sameer Kumar Prayaga during the summer of 2008 as part of the Google Summer of Code 2008 program. Dirk Eddelbuettel had suggested the topic, and acted as mentor and release coordinator.

Current maintainer team

RPostgreSQL was being maintained and extended by Joe Conway, Dirk Eddelbuettel, Tomoaki Nishiyama and Neil Tiffin.

Since release 0.2-0, Tomoaki Nishiyama is the lead maintainer.

Availability and downloads

PostgreSQL is now released on the CRAN network in both source and as a Windows binary; see the RPostgreSQL page on CRAN for details.

Initially created: Sat Jun 26 17:15:00 CST 2008
Last modified: Mon Sep 07 16:30:07 CDT 2020