RPostgreSQL v0.6-2
0
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
Details
| 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 |
| depends | DBI (>= 0.3) , methods , R (>= 2.9.0) |
| Contributors | Dirk Eddelbuettel, Joe Conway, Tomoaki Nishiyama, Sameer Prayaga, Neil Tiffin |
Include our badge in your README
[](http://www.rdocumentation.org/packages/RPostgreSQL)