Skip to content

xls2pgsql script in python to export xls | xlsx to postgres database

License

Notifications You must be signed in to change notification settings

joystor/xls2pgsql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 

Repository files navigation

xls2pgsql.py

How to use

Script to export xls or xlsx to postgres database

$ xls2pgsql.py -x <xlsfile> -e <xls_encode> -t <table to export> -h <host> -p <port> -u <user> -w <password> -d <database>

$ xls2pgsql.py -x Proyecciones_hogares_indigenas.xls -t conapo.proy_hog_indigena_10_20 -h localhost -u postgres -d db_proys

For security purposes use .pgpass to store your postgres passwords to don't use the -w option

Requiered libs

About

xls2pgsql script in python to export xls | xlsx to postgres database

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages