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.

Documentation

Manual: RPostgreSQL.pdf
Vignette: None available.

Maintainer: Tomoaki Nishiyama <tomoakin at staff.kanazawa-u.ac.jp>

Author(s): Joe Conway, Dirk Eddelbuettel, Tomoaki Nishiyama, Sameer Kumar Prayaga (during 2008), Neil Tiffin

Install package and any missing dependencies by running this line in your R console:

install.packages("RPostgreSQL")

Depends R (>= 2.9.0), methods, DBI(>=0.3)
Imports
Suggests
Enhances
Linking to
Reverse
depends
BIEN, rpostgis, rpostgisLT, RRedshiftSQL, timeseriesdb
Reverse
imports
dbfaker, postGIStools, sejmRP, stacomiR, taxizedb, TSPostgreSQL, tweet2r
Reverse
suggests
dbplyr, dplyr, etl, PivotalR, ProjectTemplate, replyr, sf, spacetime, sqldf, TSdata
Reverse
enhances
sqlutils
Reverse
linking to

Package RPostgreSQL
Materials
URL https://github.com/tomoakin/RPostgreSQL https://cran.r-project.org/package=DBI http://www.postgresql.org
Task Views
Version 0.6-2
Published 2017-06-24
License GPL-2 | file LICENSE
BugReports
SystemRequirements
NeedsCompilation yes
Citation
CRAN checks RPostgreSQL check results
Package source RPostgreSQL_0.6-2.tar.gz