Import CSV to Postgresql using Pandas
- Python 2.7
- Pandas
- sqlalchemy
--connection, -c: Postgresql database connection string, i.e. postgresql://user:pass@localhost/db_name
--file, -f: path to csv file, i.e. /Users/myusername/Documents/input.csv
--table, -t: name of table to create in database, i.e. shipping
python csv2pgsql.py -f /Users/fitzpaddy/Documents/data/input.csv -s logistics -t shipping -c postgresql://user:pass@localhost/accounts