# csv-to-pg
Create PostgreSQL statements from CSV files
## Installation
```sh
npm install -g csv-to-pg
```
## Usage
The idea for this library was to solve complex CSV scenarios, so currently each CSV requires a config file.
### config
Here is an example of a config.yaml that we can use to parse a csv that has no headers, and uses tab-delimited elements:
```yaml
input: "./myfile.tsv"
output: "./myfile.sql"
schema: myschema
table: mytable
delimeter: "\t"
headers: # order of the headers
- feature
- category
- days
- start
- end
fields:
feature: text
category: text
days: int
start: date
end:
type: date
cast: date # explicitly cast to a date type
```
You can also use JS files or JSON. If you use JS, you can also create ASTs for super custom inserts (read tests).
### run it!
Once you have a config file, simply call it and point to the config:
```sh
csv2pg ./config.yaml
```