Package: RPostgreSQL 0.7-7
Tomoaki Nishiyama
RPostgreSQL: R Interface to the 'PostgreSQL' Database System
Database interface and 'PostgreSQL' driver for 'R'. This package provides a Database Interface 'DBI' compliant driver for 'R' to access 'PostgreSQL' database systems. In order to build and install this package from source, 'PostgreSQL' itself must be present your system to provide 'PostgreSQL' functionality via its libraries and header files. These files are provided as 'postgresql-devel' package under some Linux distributions. On 'macOS' and 'Microsoft Windows' system the attached 'libpq' library source will be used.
Authors:
RPostgreSQL_0.7-7.tar.gz
RPostgreSQL_0.7-7.tar.gz(r-4.5-noble)RPostgreSQL_0.7-7.tar.gz(r-4.4-noble)
RPostgreSQL.pdf |RPostgreSQL.html✨
RPostgreSQL/json (API)
NEWS
| # Install 'RPostgreSQL' in R: |
| install.packages('RPostgreSQL', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/tomoakin/rpostgresql/issues
Last updated 3 months agofrom:7bbc76c972. Checks:OK: 2. Indexed: no.
| Target | Result | Date |
|---|---|---|
| Doc / Vignettes | OK | Dec 30 2024 |
| R-4.5-linux-x86_64 | OK | Dec 30 2024 |
Exports:coercedbApplydbBegindbCallProcdbClearResultdbColumnInfodbCommitdbConnectdbDataTypedbDisconnectdbExistsTabledbGetExceptiondbGetInfodbGetQuerydbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbListConnectionsdbListFieldsdbListResultsdbListTablesdbReadTabledbRemoveTabledbRollbackdbSendQuerydbUnloadDriverdbWriteTablefetchformatinitializeisPostgresqlIdCurrentisSQLKeywordmake.db.namesPostgreSQLpostgresqlBuildTableDefinitionpostgresqlCloneConnectionpostgresqlCloseConnectionpostgresqlCloseDriverpostgresqlCloseResultpostgresqlConnectionInfopostgresqlCopyInpostgresqlCopyInDataframepostgresqlDataTypepostgresqlDBApplypostgresqlDescribeConnectionpostgresqlDescribeDriverpostgresqlDescribeFieldspostgresqlDescribeResultpostgresqlDriverInfopostgresqlEscapeByteapostgresqlEscapeStringspostgresqlExecStatementpostgresqlFetchpostgresqlgetResultpostgresqlImportFilepostgresqlInitDriverpostgresqlNewConnectionpostgresqlpqExecpostgresqlQuickSQLpostgresqlQuoteIdpostgresqlReadTablepostgresqlResultInfopostgresqlTableRefpostgresqlUnescapeByteapostgresqlWriteTableshowSQLKeywordssummary
Dependencies:DBI
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Apply R/S-Plus functions to remote groups of DBMS rows (experimental) | dbApply |
| Apply R/S-Plus functions to remote groups of DBMS rows (experimental) | dbApply,PostgreSQLResult-method dbApply-methods |
| Call an SQL stored procedure | dbCallProc,PostgreSQLConnection-method dbCallProc-methods |
| DBMS Transaction Management | dbBegin,PostgreSQLConnection-method dbBegin-method dbCommit,PostgreSQLConnection-method dbCommit-method dbRollback,PostgreSQLConnection-method dbRollback-method PostgreSQLConnection-method |
| Create a connection object to an PostgreSQL DBMS | dbConnect,character-method dbConnect,PostgreSQLConnection-method dbConnect,PostgreSQLDriver-method dbConnect-methods dbDisconnect,PostgreSQLConnection-method dbDisconnect-methods |
| Determine the SQL Data Type of an S object | dbDataType,PostgreSQLObject-method dbDataType-methods |
| PostgreSQL implementation of the Database Interface (DBI) classes and drivers | dbDriver,character-method dbDriver-methods dbUnloadDriver,PostgreSQLDriver-method dbUnloadDriver-methods |
| Database interface meta-data | dbColumnInfo,PostgreSQLResult-method dbColumnInfo-methods dbGetDBIVersion-methods dbGetInfo dbGetInfo,PostgreSQLConnection-method dbGetInfo,PostgreSQLDriver-method dbGetInfo,PostgreSQLObject-method dbGetInfo,PostgreSQLResult-method dbGetRowCount,PostgreSQLResult-method dbGetRowCount-methods dbGetRowsAffected,PostgreSQLResult-method dbGetRowsAffected-methods dbGetStatement,PostgreSQLResult-method dbGetStatement-methods dbHasCompleted,PostgreSQLResult-method dbHasCompleted-methods |
| List items from an PostgreSQL DBMS and from objects | dbListConnections,PostgreSQLDriver-method dbListConnections-methods dbListFields,PostgreSQLConnection,character-method dbListFields,PostgreSQLResult,missing-method dbListFields-methods dbListResults,PostgreSQLConnection-method dbListResults-methods dbListTables,PostgreSQLConnection-method dbListTables-methods |
| Class dbObjectId | dbObjectId-class |
| Convenience functions for Importing/Exporting DBMS tables | dbExistsTable,PostgreSQLConnection,character-method dbExistsTable-methods dbReadTable,PostgreSQLConnection,character-method dbReadTable-methods dbRemoveTable,PostgreSQLConnection,character-method dbRemoveTable-methods dbWriteTable,PostgreSQLConnection,character,character-method dbWriteTable,PostgreSQLConnection,character,data.frame-method dbWriteTable-methods |
| Execute a statement on a given database connection | dbClearResult,PostgreSQLResult-method dbClearResult-methods dbGetException,PostgreSQLConnection-method dbGetException,PostgreSQLResult-method dbGetException-methods dbGetQuery,PostgreSQLConnection,character-method dbGetQuery-methods dbSendQuery,PostgreSQLConnection,character-method dbSendQuery-methods |
| Set data mappings between PostgreSQL and R/S-Plus | dbSetDataMappings,PostgreSQLResult,data.frame-method dbSetDataMappings-methods |
| Fetch records from a previously executed query | fetch,PostgreSQLResult,missing-method fetch,PostgreSQLResult,numeric-method fetch-methods |
| Check whether a database handle object is valid or not | isPostgresqlIdCurrent |
| Make R/S-Plus identifiers into quoted PostgreSQL identifiers | isSQLKeyword,PostgreSQLObject,character-method isSQLKeyword-methods make.db.names,PostgreSQLObject,character-method SQLKeywords,missing-method SQLKeywords,PostgreSQLObject-method SQLKeywords-methods |
| Instantiate a PostgreSQL client from the current R or S-Plus session | PostgreSQL |
| Build the SQL CREATE TABLE definition as a string | postgresqlBuildTableDefinition |
| Class PostgreSQLConnection | PostgreSQLConnection-class |
| Apply R/S-Plus functions to remote groups of DBMS rows (experimental) | postgresqlDBApply |
| Class PostgreSQLDriver | PostgreSQLDriver-class |
| Class PostgreSQLObject | PostgreSQLObject-class |
| Class PostgreSQLResult | PostgreSQLResult-class |
| Support Functions | .conflicts.OK .PostgreSQL.NA.string .PostgreSQLPkgName .PostgreSQLPkgRCS .PostgreSQLPkgVersion .PostgreSQLSQLKeywords postgresqlCloneConnection postgresqlCloseConnection postgresqlCloseDriver postgresqlCloseResult postgresqlConnectionInfo postgresqlCopyIn postgresqlCopyInDataframe postgresqlDataType postgresqlDescribeConnection postgresqlDescribeDriver postgresqlDescribeFields postgresqlDescribeResult postgresqlDriverInfo postgresqlEscapeBytea postgresqlEscapeStrings postgresqlExecStatement postgresqlFetch postgresqlgetResult postgresqlImportFile postgresqlInitDriver postgresqlNewConnection postgresqlpqExec postgresqlQuickSQL postgresqlQuoteId postgresqlReadTable postgresqlResultInfo postgresqlTableRef postgresqlTransactionStatement postgresqlUnescapeBytea postgresqlWriteTable |
| Summarize an PostgreSQL object | coerce,dbObjectId,character-method coerce,dbObjectId,integer-method coerce,dbObjectId,numeric-method coerce,PostgreSQLConnection,PostgreSQLDriver-method coerce,PostgreSQLConnection,PostgreSQLResult-method coerce,PostgreSQLObject,PostgreSQLDriver-method coerce,PostgreSQLResult,PostgreSQLConnection-method coerce,PostgreSQLResult,PostgreSQLDriver-method coerce-methods format,dbObjectId-method format-methods print,dbObjectId-method show,dbObjectId-method show-methods summary,PostgreSQLConnection-method summary,PostgreSQLDriver-method summary,PostgreSQLObject-method summary,PostgreSQLResult-method summary-methods |
