dbInsertNew: Insert New Rows

In noahbullock/extGreSQL: Extensions to RPostgreSQL

Description

Insert only those rows without an existing primary key. NOTE: This can cause a race condition under parallel execution. Use at your own risk.

Usage

dbInsertNew(conn, table, value, primary.key, colnames = names(value),
  coltypes, run = TRUE)

Arguments

conn	the database connection.
table	the table name, possibly including the schema
value	the local value to write
primary.key	the primary key or unique value constraint
colnames	the column names, if different than the names in value
coltypes	column types. If missing, an attempt is made to retrieve them from the database.
run	whether to run (TRUE) or print (FALSE) the query.

noahbullock/extGreSQL documentation built on May 23, 2019, 9:29 p.m.