The goal of rpgconn is to provide a simple interface for connecting to a PostgreSQL database.
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)install.packages("rpgconn")
# OR
remotes::install_github("r-data-science/rpgconn")library(rpgconn)
library(DBI)
#open connection
cn <- dbc("some_database")
# List tables
dbListTables(cn)
# Close connection
dbd(cn)
Need a high-speed mirror for your open-source project?
Contact our mirror admin team at info@clientvps.com.
This archive is provided as a free public service to the community.
Proudly supported by infrastructure from VPSPulse , RxServers , BuyNumber , UnitVPS , OffshoreName and secure payment technology by ArionPay.