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