insert_into_returning: Insert values into table returning the primary key

In vimc/dettl: Data Extract, Transform, Test and Load

Insert values into table returning the primary key

Description

Checks whether the table already has values matching

Usage

insert_into_returning(con, table, d, key = NULL, ret = NULL)

Arguments

con	Connection to db to insert values into.
table	Name of table to insert values into.
d	Data frame of data to be inserted into db.
key	Keys to check for already existing in the database. If trying to add a new row with unique key constraints use this to check for existing entries with same information.
ret	The fields to return, defaults to using "id"

Value

List of returned ids from inserted values.

vimc/dettl documentation built on Oct. 6, 2022, 2:13 p.m.