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