Get index id by unique_columns.

Get index id by unique_columns.

getIdByUniqueIndex(
  con,
  table,
  data,
  unique_col = "name",
  data_col = unique_col,
  ignore_case = FALSE
)

Arguments

con

a connection object as produced by dbConnect

table

the table name

data

A data frame to write into table

unique_col

A character vector to identify each row in the table

data_col

The column names in the data.frame

ignore_case

Whether ignore_case

Value

id of unique_col