Package: RPostgres 1.4.10.9009

Kirill Müller

RPostgres: C++ Interface to PostgreSQL

Fully DBI-compliant C++-backed interface to PostgreSQL <https://www.postgresql.org/>, an open-source relational database.

Authors:Hadley Wickham [aut], Jeroen Ooms [aut], Kirill Müller [aut, cre], RStudio [cph], R Consortium [fnd], Tomoaki Nishiyama [ctb]

RPostgres_1.4.10.9009.tar.gz
RPostgres_1.4.10.9009.zip(r-4.7)RPostgres_1.4.10.9009.zip(r-4.6)RPostgres_1.4.10.9009.zip(r-4.5)
RPostgres_1.4.10.9009.tgz(r-4.6-x86_64)RPostgres_1.4.10.9009.tgz(r-4.6-arm64)RPostgres_1.4.10.9009.tgz(r-4.5-x86_64)RPostgres_1.4.10.9009.tgz(r-4.5-arm64)
RPostgres_1.4.10.9009.tar.gz(r-4.7-arm64)RPostgres_1.4.10.9009.tar.gz(r-4.7-x86_64)RPostgres_1.4.10.9009.tar.gz(r-4.6-arm64)RPostgres_1.4.10.9009.tar.gz(r-4.6-x86_64)
manual.pdf |manual.html✨
card.svg |card.png
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

Pkgdown/docs site:https://rpostgres.r-dbi.org

Uses libs:
  • postgresql– PostgreSQL C client library
  • c++– GNU Standard C++ Library v3

On CRAN:

Conda:

databasepostgrespostgresqlcpp

15.48 score 337 stars 40 packages 3.9k scripts 54k downloads 1 mentions 50 exports 16 dependencies

Last updated from:567d0fe7fb. Checks:12 OK, 1 FAIL. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-arm64OK161
linux-devel-x86_64OK160
source / vignettesOK258
linux-release-arm64OK156
linux-release-x86_64OK169
macos-release-arm64OK108
macos-release-x86_64OK332
macos-oldrel-arm64OK101
macos-oldrel-x86_64OK208
windows-develOK480
windows-releaseOK445
windows-oldrelOK456
wasm-releaseFAIL146

Exports:dbAppendTabledbBegindbBinddbCanConnectdbClearResultdbColumnInfodbCommitdbConnectdbCreateTabledbDataTypedbDisconnectdbDriverdbExecutedbExistsTabledbFetchdbGetInfodbGetQuerydbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsReadOnlydbIsValiddbListFieldsdbListObjectsdbListResultsdbListTablesdbQuoteIdentifierdbQuoteLiteraldbQuoteStringdbReadTabledbRemoveTabledbRollbackdbSendQuerydbSendStatementdbUnloadDriverdbUnquoteIdentifierdbWithTransactiondbWriteTableIdPostgrespostgresDefaultpostgresExportLargeObjectpostgresHasDefaultpostgresImportLargeObjectpostgresIsTransactingpostgresWaitForNotifyRedshiftshowsqlData

Dependencies:bitbit64blobclicpp11DBIgenericsgluehmslifecyclelubridatepkgconfigrlangtimechangevctrswithr

Implementing a Work Queue using RPostgres

Jamie Lentin

Rendered fromwork-queue.Rmdusingknitr::rmarkdownon May 24 2026.

Last update: 2026-02-15
Started: 2020-10-18

Readme and manuals

Help Manual

Help pageTopics
RPostgres: C++ Interface to PostgreSQLRPostgres-package RPostgres
Postgres driverdbConnect,PqDriver-method dbConnect_PqDriver dbDisconnect,PqConnection-method dbDisconnect_PqConnection Postgres
Execute a SQL statement on a database connectiondbBind,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 tablesdbAppendTable,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
Exports a large object to filepostgresExportLargeObject
Check if default database is available.postgresDefault postgresHasDefault
Imports a large object from filepostgresImportLargeObject
Return whether a transaction is ongoingpostgresIsTransacting
Wait for and return any notifications that return within timeoutpostgresWaitForNotify
Quote postgres strings, identifiers, and literalsdbQuoteIdentifier,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/connectiondbConnect,RedshiftDriver-method dbConnect_RedshiftDriver Redshift RedshiftConnection-class RedshiftDriver-class