A simple and fast cli application to load a csv into postgres
Project description
csv2pg
A simple and fast cli application to load a csv into postgres
Installation
pip install csv2pg
Usage
csv2pg expects the same parameter than psql to setup the postgres connection
csv2pg -h localhost -p 5432 -U postgres -d postgres public.my_table data.csv --verbose
PGHOST=mypg.host.com PGPORT=5432 PGDATABASE=mydb PGUSER=myuser csv2pg public.my_table data.csv --verbose
csv2pg --help
Dialect discovery
With python csv.Sniffer() class the csv parameters like delimiter
, quotechar
, escapechar
, lineterminator
are automatically detected. They can be overriden with cli options.
Basic database utilities
csv2pg will automatically create the table using the header of the csv file. Caution, the option --overwrite
will drop the table before inserting the new records in.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
csv2pg-1.0.0b1.tar.gz
(4.0 kB
view hashes)