load csv data into database

Source: R/db.R

load csv data into database

csv_to_db(con, pfx = "/Users/bbest/docker_pg_data/aquamaps_csv",
  pfx_db = "/data/aquamaps_csv", tbl_csv = list(spp =
  "speciesoccursum_ver0816c.csv", obs_cells =
  "occurrencecells_ver0816c.csv", env_cells = "hcaf_v6.csv", spp_cells =
  "hcaf_species_native_ver0816c.csv"), redo = T)

Arguments

con

database connection
pfx

prefix for locally available data
pfx_db

prefix on database server
tbl_csv

named list of database table names = csv's to import

Value

TRUE

Examples

# NOT RUN {
csv_to_db(con)
# }