RPostgreSQL v0.6-2


Monthly downloads



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.

Functions in RPostgreSQL

Name Description
PostgreSQL Instantiate a PostgreSQL client from the current R or S-Plus session
PostgreSQLConnection-class Class PostgreSQLConnection
PostgreSQLDriver-class Class PostgreSQLDriver
PostgreSQLObject-class Class PostgreSQLObject
dbConnect-methods Create a connection object to an PostgreSQL DBMS
dbDataType-methods Determine the SQL Data Type of an S object
dbReadTable-methods Convenience functions for Importing/Exporting DBMS tables
dbSendQuery-methods Execute a statement on a given database connection
postgresqlBuildTableDefinition Build the SQL CREATE TABLE definition as a string
postgresqlDBApply Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
PostgreSQLResult-class Class PostgreSQLResult
S4R R compatibility with S version 4/Splus5+ support functions
dbDriver-methods PostgreSQL implementation of the Database Interface (DBI) classes and drivers
dbGetInfo-methods Database interface meta-data
make.db.names-methods Make R/S-Plus identifiers into quoted PostgreSQL identifiers
dbApply-methods Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
dbApply Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
dbListTables-methods List items from an PostgreSQL DBMS and from objects
dbObjectId-class Class dbObjectId
dbCallProc-methods Call an SQL stored procedure
dbCommit-methods DBMS Transaction Management
dbSetDataMappings-methods Set data mappings between PostgreSQL and R/S-Plus
isPostgresqlIdCurrent Check whether a database handle object is valid or not
fetch-methods Fetch records from a previously executed query
postgresqlSupport Support Functions
summary-methods Summarize an PostgreSQL object
No Results!

Last month downloads


Date 2017-06-24
LazyLoad true
License GPL-2 | file LICENSE
Copyright Authors listed above, PostgreSQL Global Development Group, and The Regents of the University of California
Collate S4R.R zzz.R PostgreSQLSupport.R dbObjectId.R PostgreSQL.R
URL https://github.com/tomoakin/RPostgreSQL, https://cran.r-project.org/package=DBI, http://www.postgresql.org
NeedsCompilation yes
Packaged 2017-06-24 03:16:20 UTC; tomoaki
Repository CRAN
Date/Publication 2017-06-24 07:17:52 UTC

Include our badge in your README