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