This package is considered a duplicate. The official version of this package is found at:https://r-dbi.r-universe.dev/RPostgres

Package: RPostgres 1.4.10.9010

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]

# Install 'RPostgres' in R:

install.packages('RPostgres', repos = c('https://cynkra.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:

database postgres postgresql cpp

15.49 score 339 stars 41 packages 3.6k scripts 55k downloads 1 mentions 50 exports 16 dependencies

Last updated from:849cbf727f. Checks:12 OK, 1 FAIL. Indexed: no.

Target	Result	Time
linux-devel-arm64	OK	176
linux-devel-x86_64	OK	170
source / vignettes	OK	239
linux-release-arm64	OK	166
linux-release-x86_64	OK	164
macos-release-arm64	OK	160
macos-release-x86_64	OK	331
macos-oldrel-arm64	OK	119
macos-oldrel-x86_64	OK	192
windows-devel	OK	461
windows-release	OK	517
windows-oldrel	OK	497
wasm-release	FAIL	132

Exports:dbAppendTable dbBegin dbBind dbCanConnect dbClearResult dbColumnInfo dbCommit dbConnect dbCreateTable dbDataType dbDisconnect dbDriver dbExecute dbExistsTable dbFetch dbGetInfo dbGetQuery dbGetRowCount dbGetRowsAffected dbGetStatement dbHasCompleted dbIsReadOnly dbIsValid dbListFields dbListObjects dbListResults dbListTables dbQuoteIdentifier dbQuoteLiteral dbQuoteString dbReadTable dbRemoveTable dbRollback dbSendQuery dbSendStatement dbUnloadDriver dbUnquoteIdentifier dbWithTransaction dbWriteTable Id Postgres postgresDefault postgresExportLargeObject postgresHasDefault postgresImportLargeObject postgresIsTransacting postgresWaitForNotify Redshift show sqlData

Dependencies:bit bit64 blob cli cpp11 DBI generics glue hms lifecycle lubridate pkgconfig rlang timechange vctrs withr

Implementing a Work Queue using RPostgres

LISTEN / NOTIFY | SKIP LOCKED | Implementing our worker

Rendered fromwork-queue.Rmdusingknitr::rmarkdown

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

Citation

Development and contributors

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
Exports a large object to file	postgresExportLargeObject
Check if default database is available.	postgresDefault postgresHasDefault
Imports a large object from file	postgresImportLargeObject
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