csv-to-pg

Create PostgreSQL statements from CSV files

Installation

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:

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:

csv2pg ./config.yaml