nz_import_dir_to_db
: import directory
Description
Import a directory into database. The directory must have a set of csv files
Usage
nz_import_dir_to_db(
DSN,
directory,
table_name,
value_type = "varchar",
createTable = T,
max_errors = 2
)
Arguments
Argument | Description |
---|---|
DSN |
The NZ DSN object made by nz_init |
directory |
Directory of CSV files |
table_name |
Name of the table to import data into |
value_type |
The type of Value possible options float, varchar, integer, bigint |
createTable |
Either make a new table and drop table if exists or append data to the existing table |
max_errors |
The maximumn number of rows in the csv which can include error in their values |
Value
Examples
nz_import_dir_to_db()
Last update: August 28, 2020