Skip to content
Load CSV files into Postgres without explicit schema creation.
Python Makefile
Branch: master
Clone or download
Type Name Latest commit message Commit time
Failed to load latest commit information.
pgcsv Add support for python3 Aug 10, 2018
.gitignore Refactor to make much more stable. Oct 23, 2017
LICENSE initial commit Feb 5, 2017
Makefile release tools Oct 23, 2017 initial commit Feb 5, 2017
setup.cfg release Feb 5, 2017 i have no idea how these categories work Aug 10, 2018


The purpose of pgcsv is to make a CSV file show up in a database. To this end, it will automatically create the table schema and COPY data. It will not attempt to perform type inference. It will not attempt to fix up your CSV file (the file is assumed to be readable as UTF-8 with the first row containing column headers).


$ pip install pgcsv
$ pgcsv --db postgresql://localhost/database new_table csv_file.csv
You can’t perform that action at this time.