RPostgreSQL: R interface to the PostgreSQL database system
R上でPostgreSQLを操作するパッケージ
- CRAN: http://cran.r-project.org/web/packages/RPostgreSQL/index.html
- URL: https://code.google.com/p/rpostgresql/, http://www.stat.bell-labs.com/RS-DBI, http://www.postgresql.org
> library(RPostgreSQL)
Error: package or namespace load failed for 'RPostgreSQL'
バージョン: 0.4
関数名 | 概略 |
---|---|
PostgreSQL |
Instantiate a PostgreSQL client from the current R or S-Plus session |
PostgreSQLConnection-class |
Class PostgreSQLConnection |
PostgreSQLDriver-class |
Class PostgreSQLDriver |
PostgreSQLObject-class |
Class PostgreSQLObject |
PostgreSQLResult-class |
Class PostgreSQLResult |
SQLKeywords-methods |
Make R/S-Plus identifiers into quoted PostgreSQL identifiers |
dbApply |
Apply R/S-Plus functions to remote groups of DBMS rows (experimental) |
dbApply-methods |
Apply R/S-Plus functions to remote groups of DBMS rows (experimental) |
dbCallProc-methods |
Call an SQL stored procedure |
dbCommit-methods |
DBMS Transaction Management |
dbConnect-methods |
Create a connection object to an PostgreSQL DBMS |
dbDataType-methods |
Determine the SQL Data Type of an S object |
dbDriver-methods |
PostgreSQL implementation of the Database Interface (DBI) classes and drivers |
dbGetInfo |
Database interface meta-data |
dbListTables-methods |
List items from an PostgreSQL DBMS and from objects |
dbObjectId-class |
Class dbObjectId |
dbReadTable-methods |
Convenience functions for Importing/Exporting DBMS tables |
dbSendQuery-methods |
Execute a statement on a given database connection |
dbSetDataMappings-methods |
Set data mappings between PostgreSQL and R/S-Plus |
fetch-methods |
Fetch records from a previously executed query |
isPostgresqlIdCurrent |
Check whether a database handle object is valid or not |
postgresqlBuildTableDefinition |
Build the SQL CREATE TABLE definition as a string |
postgresqlDBApply |
Apply R/S-Plus functions to remote groups of DBMS rows (experimental) |
postgresqlInitDriver |
Support Functions |
summary-methods |
Summarize an PostgreSQL object |