RPostgreSQL

v. 
by Tomoaki Nishiyama
0

Monthly downloads

0th

Percentile

0
Date $Date: 2013-03-27 15:32:53 +0900 (Wed, 27 Mar 2013) $
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://code.google.com/p/rpostgresql/, http://www.stat.bell-labs.com/RS-DBI, http://www.postgresql.org
Packaged 2016-05-08 20:59:35 UTC; ligges
NeedsCompilation yes
Repository CRAN
Date/Publication 2016-05-08 23:09:20

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 Microsoft Windows system the attached libpq library source will be used. A wiki and issue tracking system for the package are available at Google Code at https://code.google.com/p/rpostgresql/ .

Functions in RPostgreSQL

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

Dependencies

Get your badge !

[![Rdoc](http://www.rdocumentation.org/badges/version/RPostgreSQL)](http://www.rdocumentation.org/packages/RPostgreSQL)