Rdocumentation
powered by
Learn R Programming
⚠️
There's a newer version (0.7-8) of this package.
Take me there.
RPostgreSQL (version 0.1-2)
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-2
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-2)
Search all functions
dbConnect-methods
Create a connection object to an PostgreSQL DBMS
dbApply-methods
Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
PostgreSQLConnection-class
Class PostgreSQLConnection
S4R
R compatibility with S version 4/Splus5+ support functions
dbDriver-methods
PostgreSQL implementation of the Database Interface (DBI) classes and drivers
PostgreSQL
Instantiate a PostgreSQL client from the current R or S-Plus session
dbApply
Apply R/S-Plus functions to remote groups of DBMS rows (experimental)
dbGetInfo-methods
Database interface meta-data
dbSetDataMappings-methods
Set data mappings between PostgreSQL and R/S-Plus
dbDataType-methods
Determine the SQL Data Type of an S object
make.db.names-methods
Make R/S-Plus identifiers into legal SQL identifiers
dbListTables-methods
List items from an PostgreSQL DBMS and from objects
PostgreSQLResult-class
Class PostgreSQLResult
isIdCurrent
Check whether a database handle object is valid or not
PostgreSQLDriver-class
Class PostgreSQLDriver
dbCallProc-methods
Call an SQL stored procedure
dbBuildTableDefinition
Build the SQL CREATE TABLE definition as a string
dbReadTable-methods
Convenience functions for Importing/Exporting DBMS tables
summary-methods
Summarize an PostgreSQL object
safe.write
Write a data.frame avoiding exceeding memory limits
dbObjectId-class
Class dbObjectId
postgresqlSupport
Support Functions
PostgreSQLObject-class
Class PostgreSQLObject
fetch-methods
Fetch records from a previously executed query
dbCommit-methods
DBMS Transaction Management
dbSendQuery-methods
Execute a statement on a given database connection
postgresqlDBApply
Apply R/S-Plus functions to remote groups of DBMS rows (experimental)