Learn R Programming

RPostgreSQL (version 0.7-8)

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

Copy Link

Version

Install

install.packages('RPostgreSQL')

Monthly Downloads

47,240

Version

0.7-8

License

GPL-3 | file LICENSE

Issues

42

Pull Requests

2

Stars

66

Forks

20

Maintainer

Tomoaki Nishiyama

Last Published

March 28th, 2025

Functions in RPostgreSQL (0.7-8)

dbGetInfo-methods

Database interface meta-data
dbSendQuery-methods

Execute a statement on a given database connection
dbListTables-methods

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

Create a connection object to an PostgreSQL DBMS
dbDataType-methods

Determine the SQL Data Type of an S object
isPostgresqlIdCurrent

Check whether a database handle object is valid or not
make.db.names-methods

Make R/S-Plus identifiers into quoted PostgreSQL identifiers
fetch-methods

Fetch records from a previously executed query
postgresqlSupport

Support Functions
summary-methods

Summarize an PostgreSQL object
postgresqlBuildTableDefinition

Build the SQL CREATE TABLE definition as a string
dbObjectId-class

Class dbObjectId
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
PostgreSQLObject-class

Class PostgreSQLObject
PostgreSQLConnection-class

Class PostgreSQLConnection
dbCallProc-methods

Call an SQL stored procedure
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)
dbCommit-methods

DBMS Transaction Management
PostgreSQL

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

Class PostgreSQLDriver
dbDriver-methods

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

Convenience functions for Importing/Exporting DBMS tables
dbSetDataMappings-methods

Set data mappings between PostgreSQL and R/S-Plus