Learn R Programming
⚠️There's a newer version (0.7-8) of this package.Take me there.

RPostgreSQL (version 0.2-0)

R interface to the PostgreSQL database system

Description

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 through its libraries and header files. A wiki and issue tracking system for the package are available at Google Code at https://code.google.com/p/rpostgresql/ .

Copy Link

Version

Install

install.packages('RPostgreSQL')

Monthly Downloads

46,438

Version

0.2-0

License

GPL-2

Maintainer

Tomoaki Nishiyama

Last Published

October 4th, 2011

Functions in RPostgreSQL (0.2-0)

dbApply

Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
dbApply-methods

Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
dbGetInfo-methods

Database interface meta-data
dbSendQuery-methods

Execute a statement on a given database connection
dbDataType-methods

Determine the SQL Data Type of an S object
dbCallProc-methods

Call an SQL stored procedure
dbBuildTableDefinition

Build the SQL CREATE TABLE definition as a string
summary-methods

Summarize an PostgreSQL object
PostgreSQLDriver-class

Class PostgreSQLDriver
PostgreSQLConnection-class

Class PostgreSQLConnection
PostgreSQLObject-class

Class PostgreSQLObject
PostgreSQL

Instantiate a PostgreSQL client from the current R or S-Plus session
make.db.names-methods

Make R/S-Plus identifiers into legal SQL identifiers
dbObjectId-class

Class dbObjectId
dbConnect-methods

Create a connection object to an PostgreSQL DBMS
dbCommit-methods

DBMS Transaction Management
PostgreSQLResult-class

Class PostgreSQLResult
dbSetDataMappings-methods

Set data mappings between PostgreSQL and R/S-Plus
dbReadTable-methods

Convenience functions for Importing/Exporting DBMS tables
dbListTables-methods

List items from an PostgreSQL DBMS and from objects
dbDriver-methods

PostgreSQL implementation of the Database Interface (DBI) classes and drivers
isIdCurrent

Check whether a database handle object is valid or not
fetch-methods

Fetch records from a previously executed query
postgresqlDBApply

Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
postgresqlSupport

Support Functions
safe.write

Write a data.frame avoiding exceeding memory limits
S4R

R compatibility with S version 4/Splus5+ support functions