csvpsql

csvpsql generate Postgres table from csv file.

Installation

bash cargo install csvpsql

Usage

```bash USAGE: csvpsql [FLAGS] [OPTIONS] --table-name [file]

FLAGS: --drop To drop the table if exists -h, --help Prints help information --no-copy To remove copy command --no-header Whenever the csv file has no header -V, --version Prints version information

OPTIONS: -c, --columns Override column name. Separated by comma. Use the csv header or letters by default. -d, --delimiter [default: ,] -n, --null-as Empty string are null by default [default: ] -t, --table-name File name is used as default

ARGS: ```

Example

```bash $ csvpsql --drop example.csv drop table if exists example;

create table example ( city text not null, region text not null, country text not null, population integer not null );

\copy example from 'example.csv' with csv delimiter ',' header; ```