Package: RPostgres 1.4.7.9012
RPostgres: C++ Interface to PostgreSQL
Fully DBI-compliant C++-backed interface to PostgreSQL <https://www.postgresql.org/>, an open-source relational database.
Authors:
RPostgres_1.4.7.9012.tar.gz
RPostgres_1.4.7.9012.zip(r-4.5)RPostgres_1.4.7.9012.zip(r-4.4)RPostgres_1.4.7.9012.zip(r-4.3)
RPostgres_1.4.7.9012.tgz(r-4.4-x86_64)RPostgres_1.4.7.9012.tgz(r-4.4-arm64)RPostgres_1.4.7.9012.tgz(r-4.3-x86_64)RPostgres_1.4.7.9012.tgz(r-4.3-arm64)
RPostgres_1.4.7.9012.tar.gz(r-4.5-noble)RPostgres_1.4.7.9012.tar.gz(r-4.4-noble)
RPostgres.pdf |RPostgres.html✨
RPostgres/json (API)
NEWS
# Install 'RPostgres' in R: |
install.packages('RPostgres', repos = c('https://r-dbi.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/r-dbi/rpostgres/issues
Last updated 11 days agofrom:b62bc601a2. Checks:OK: 9. Indexed: yes.
Target | Result | Date |
---|---|---|
Doc / Vignettes | OK | Oct 28 2024 |
R-4.5-win-x86_64 | OK | Oct 28 2024 |
R-4.5-linux-x86_64 | OK | Oct 28 2024 |
R-4.4-win-x86_64 | OK | Oct 28 2024 |
R-4.4-mac-x86_64 | OK | Oct 28 2024 |
R-4.4-mac-aarch64 | OK | Oct 28 2024 |
R-4.3-win-x86_64 | OK | Oct 28 2024 |
R-4.3-mac-x86_64 | OK | Oct 28 2024 |
R-4.3-mac-aarch64 | OK | Oct 28 2024 |
Exports:dbAppendTabledbBegindbBinddbCanConnectdbClearResultdbColumnInfodbCommitdbConnectdbCreateTabledbDataTypedbDisconnectdbDriverdbExecutedbExistsTabledbFetchdbGetInfodbGetQuerydbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsReadOnlydbIsValiddbListFieldsdbListObjectsdbListResultsdbListTablesdbQuoteIdentifierdbQuoteLiteraldbQuoteStringdbReadTabledbRemoveTabledbRollbackdbSendQuerydbSendStatementdbUnloadDriverdbUnquoteIdentifierdbWithTransactiondbWriteTableIdPostgrespostgresDefaultpostgresHasDefaultpostgresIsTransactingpostgresWaitForNotifyRedshiftshowsqlData
Dependencies:bitbit64blobclicpp11DBIgenericsgluehmslifecyclelubridatepkgconfigplogrrlangtimechangevctrswithr
Readme and manuals
Help Manual
Help page | Topics |
---|---|
RPostgres: C++ Interface to PostgreSQL | RPostgres-package RPostgres |
Postgres driver | dbConnect,PqDriver-method dbConnect_PqDriver dbDisconnect,PqConnection-method dbDisconnect_PqConnection Postgres |
Execute a SQL statement on a database connection | dbBind,PqResult-method dbBind_PqResult dbClearResult,PqResult-method dbClearResult_PqResult dbFetch,PqResult-method dbFetch_PqResult dbHasCompleted,PqResult-method dbHasCompleted_PqResult dbSendQuery,PqConnection-method dbSendQuery_PqConnection postgres-query |
Convenience functions for reading/writing DBMS tables | dbAppendTable,PqConnection-method dbAppendTable_PqConnection dbExistsTable,PqConnection,character-method dbExistsTable,PqConnection,Id-method dbExistsTable_PqConnection_character dbExistsTable_PqConnection_Id dbListFields,PqConnection,character-method dbListFields,PqConnection,Id-method dbListFields_PqConnection_character dbListFields_PqConnection_Id dbListObjects,PqConnection-method dbListObjects_PqConnection_ANY dbListTables,PqConnection-method dbListTables_PqConnection dbReadTable,PqConnection,character-method dbReadTable_PqConnection_character dbRemoveTable,PqConnection,character-method dbRemoveTable_PqConnection_character dbWriteTable,PqConnection,character,data.frame-method dbWriteTable_PqConnection_character_data.frame postgres-tables sqlData,PqConnection-method sqlData_PqConnection |
Transaction management. | dbBegin,PqConnection-method dbBegin_PqConnection dbCommit,PqConnection-method dbCommit_PqConnection dbRollback,PqConnection-method dbRollback_PqConnection postgres-transactions |
Check if default database is available. | postgresDefault postgresHasDefault |
Return whether a transaction is ongoing | postgresIsTransacting |
Wait for and return any notifications that return within timeout | postgresWaitForNotify |
Quote postgres strings, identifiers, and literals | dbQuoteIdentifier,PqConnection,character-method dbQuoteIdentifier,PqConnection,Id-method dbQuoteIdentifier,PqConnection,SQL-method dbQuoteIdentifier_PqConnection_character dbQuoteIdentifier_PqConnection_Id dbQuoteIdentifier_PqConnection_SQL dbQuoteLiteral,PqConnection-method dbQuoteLiteral_PqConnection dbQuoteString,PqConnection,character-method dbQuoteString,PqConnection,SQL-method dbQuoteString_PqConnection_character dbQuoteString_PqConnection_SQL dbUnquoteIdentifier,PqConnection,SQL-method dbUnquoteIdentifier_PqConnection_SQL quote |
Redshift driver/connection | dbConnect,RedshiftDriver-method dbConnect_RedshiftDriver Redshift RedshiftConnection-class RedshiftDriver-class |