johnsorianodev / excel-postgresql-batch-upload Public

Notifications You must be signed in to change notification settings
Fork 0
Star 0

Script for uploading batch files of excel in postgresql. Automatically calculate character value if column is string to optimized memory allocation.

0 stars 0 forks Branches Tags Activity

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 3 Commits
.gitattributes		.gitattributes
LICENSE		LICENSE
README.md		README.md
script.py		script.py

Repository files navigation

excel-postgresql-batch-upload

Script for uploading batch files of excel in postgresql. Automatically calculate character value if column is string to optimized memory allocation.

Installation

git clone https://github.com/john-soriano/excel-postgresql-batch-upload.git
cd insert-batch
change parameters in the source code
pip install psycopg2 pandas sqlalchemy openpyxl
python script.py

About

Script for uploading batch files of excel in postgresql. Automatically calculate character value if column is string to optimized memory allocation.

Report repository

Releases 1

Initial release Latest

Packages

No packages published

Languages

Python 100.0%