The hardware and bandwidth for this mirror is donated by METANET, the Webhosting and Full Service-Cloud Provider.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]metanet.ch.

rpgconn

The goal of rpgconn is to provide a simple interface for connecting to a PostgreSQL database.

Setting RPG_CONN_STRING

The environment variable RPG_CONN_STRING must be set and have the format shown below.

cs <- "user=postgres;password=some_password;host=some_host;port=5432;dbname=postgres"
Sys.setenv(RPG_CONN_STRING = cs)

Installation

install.packages("rpgconn")
# OR
remotes::install_github("r-data-science/rpgconn")

Example

library(rpgconn)
library(DBI)

#open connection
cn <- dbc("some_database")

# List tables
dbListTables(cn)

# Close connection
dbd(cn)

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.