qrc_insert: qrc_insert

In kimjam/srms: Package to automate tasks and reporting for OCD SRMS Team.

Description

A function to write dataframes to PostgreSQL database.

Usage

qrc_insert(table, df, db, dbhost = Sys.getenv("QRC_DB_HOST"), port = 5432,
  uid = Sys.getenv("QRC_DB_USER"), pwd = Sys.getenv("QRC_DB_PWD"), ...)

Arguments

table	Name of table to insert to.
df	Dataframe to insert.
dbhost	Host IP address. Set to QRC_DB_HOST in .Renviron.
port	Port that server is listening on. Defaults to 5432.
uid	User ID. Set as QRC_DB_USER in .Renviron file.
pwd	Password. Set as QRC_DB_PWD in .Renviron file.
...	Additional arguments such as append or overwrite.

kimjam/srms documentation built on May 20, 2019, 10:21 p.m.