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

RPostgreSQL (version 0.1-7)

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. 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.1-7

License

GPL-2

Maintainer

Dirk Eddelbuettel

Last Published

October 17th, 2010

Functions in RPostgreSQL (0.1-7)

dbApply

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

Build the SQL CREATE TABLE definition as a string
make.db.names-methods

Make R/S-Plus identifiers into legal SQL identifiers
dbSetDataMappings-methods

Set data mappings between PostgreSQL and R/S-Plus
PostgreSQLObject-class

Class PostgreSQLObject
dbGetInfo-methods

Database interface meta-data
isIdCurrent

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

PostgreSQL implementation of the Database Interface (DBI) classes and drivers
dbConnect-methods

Create a connection object to an PostgreSQL DBMS
dbReadTable-methods

Convenience functions for Importing/Exporting DBMS tables
S4R

R compatibility with S version 4/Splus5+ support functions
fetch-methods

Fetch records from a previously executed query
dbApply-methods

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

Class PostgreSQLDriver
dbCommit-methods

DBMS Transaction Management
PostgreSQLResult-class

Class PostgreSQLResult
dbListTables-methods

List items from an PostgreSQL DBMS and from objects
postgresqlDBApply

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

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

Summarize an PostgreSQL object
dbCallProc-methods

Call an SQL stored procedure
PostgreSQLConnection-class

Class PostgreSQLConnection
safe.write

Write a data.frame avoiding exceeding memory limits
PostgreSQL

Instantiate a PostgreSQL client from the current R or S-Plus session
postgresqlSupport

Support Functions
dbObjectId-class

Class dbObjectId
dbSendQuery-methods

Execute a statement on a given database connection