# csvpsql
`csvpsql` generate Postgres table from csv file.
## Installation
```bash
cargo install csvpsql
```
## Usage
```bash
USAGE:
csvpsql [FLAGS] [OPTIONS] --table-name <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 <columns> Override column name. Separated by comma. Use the csv header or letters by default.
-d, --delimiter <delimiter> [default: ,]
-n, --null-as <null-as> Empty string are null by default [default: ]
-t, --table-name <table-name> File name is used as default
ARGS:
<file>
```
## 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;
```