csv2postgresql imports data from a CSV file into PostgreSQL.
It differs from PostgreSQL COPY FROM ... WITH (FORMAT CSV ...) command as it
detects automatically the CSV columns available, so even CSV files with missing
columns or having columns arranged in a different order can be easily imported.
The software can be installed using pip or pipx, which is preferred.
pipx install csv2postgresql
$ csv2postgresql --help
usage: csv2postgresql [-h] [--input-file INPUT_FILE] [--delimiter DELIMITER] [--quotechar QUOTECHAR]
[--escapechar ESCAPECHAR] [--encoding ENCODING]
dsn table
Load CSV with header into PostgreSQL
positional arguments:
dsn
table
optional arguments:
-h, --help show this help message and exit
--input-file INPUT_FILE, -i INPUT_FILE
Input file name containing a valid CSV.
--delimiter DELIMITER, -d DELIMITER
--quotechar QUOTECHAR
--escapechar ESCAPECHAR
--encoding ENCODING, -e ENCODING
csv2postgresql -i table.csv postgresql://user:password@localhost/db table