Rdocumentation
powered by
Learn R Programming
⚠️
There's a newer version (0.7-8) of this package.
Take me there.
RPostgreSQL (version 0.1-1)
R interface to the PostgreSQL database system
Description
Database interface and PostgreSQL driver for R. This version complies with the database interface definition as implemented in the package DBI.
Copy Link
Link to current version
Version
Version
0.7-8
0.7-7
0.7-6
0.7-5
0.7-4
0.7-3
0.7-2
0.7
0.6-2
0.4-1
0.3-3
0.3-2
0.3-1
0.3-0
0.2-1
0.2-0
0.1-7
0.1-6
0.1-5
0.1-4
0.1-3
0.1-2
0.1-1
0.1-0
Install
install.packages('RPostgreSQL')
Monthly Downloads
46,438
Version
0.1-1
License
GPL-2
Homepage
http://www.stat.bell-labs.com/RS-DBI
Maintainer
Dirk Eddelbuettel
Last Published
March 28th, 2025
Functions in RPostgreSQL (0.1-1)
Search all functions
dbApply-methods
Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
dbCommit-methods
DBMS Transaction Management
dbApply
Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
dbDriver-methods
PostgreSQL implementation of the Database Interface (DBI) classes and drivers
dbObjectId-class
Class dbObjectId
dbConnect-methods
Create a connection object to an PostgreSQL DBMS
dbCallProc-methods
Call an SQL stored procedure
PostgreSQLResult-class
Class PostgreSQLResult
S4R
R compatibility with S version 4/Splus5+ support functions
dbListTables-methods
List items from an PostgreSQL DBMS and from objects
fetch-methods
Fetch records from a previously executed query
make.db.names-methods
Make R/S-Plus identifiers into legal SQL identifiers
dbSendQuery-methods
Execute a statement on a given database connection
PostgreSQLDriver-class
Class PostgreSQLDriver
PostgreSQL
Instantiate a PostgreSQL client from the current R or S-Plus session
postgresqlDBApply
Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
isIdCurrent
Check whether a database handle object is valid or not
dbSetDataMappings-methods
Set data mappings between PostgreSQL and R/S-Plus
safe.write
Write a data.frame avoiding exceeding memory limits
postgresqlSupport
Support Functions
summary-methods
Summarize an PostgreSQL object
dbReadTable-methods
Convenience functions for Importing/Exporting DBMS tables
dbBuildTableDefinition
Build the SQL CREATE TABLE definition as a string
dbGetInfo-methods
Database interface meta-data
PostgreSQLObject-class
Class PostgreSQLObject
dbDataType-methods
Determine the SQL Data Type of an S object
PostgreSQLConnection-class
Class PostgreSQLConnection