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