Skip to content

This application (exe) can take csv file path and table_name as an input from user and then load the csv file directly to postgreSQL database called - projectBloom. Modify the "conn" dict in the py code by adding your postgreSQL connection info and then run the command to create exe using pyinstaller pkg, and just RUN exe. See the magic!

Notifications You must be signed in to change notification settings

isumitsr/CSVLoaderPostgreSQL

Repository files navigation

CSVLoaderPostgreSQL

This application (exe) can take csv file path and table_name as an input from user and then load the csv file directly to postgreSQL database called - projectBloom. Modify the "conn" dict in the py code by adding your postgreSQL connection info and then run the command to create exe using pyinstaller pkg, and just RUN exe. See the magic!

Once App is opened, confirm whether to use default DB or give custom DB as an input

Screenshot 2024-09-05 at 2 03 20 AM

Give inputs

Screenshot 2024-09-05 at 2 03 52 AM

Provide csv file path (you can browse and let the app choose it now), table name and schema (optional, default is public) that should be created automatically in PostGreSQL through csv file. And data to be loaded in that table.

Screenshot 2024-09-11 at 12 06 45 AM

Successful Message!!!

Screenshot 2024-09-05 at 2 05 23 AM

DATA LOADED SUCCESFULLY, Can check the DB now!!!

About

This application (exe) can take csv file path and table_name as an input from user and then load the csv file directly to postgreSQL database called - projectBloom. Modify the "conn" dict in the py code by adding your postgreSQL connection info and then run the command to create exe using pyinstaller pkg, and just RUN exe. See the magic!

Resources

Stars

Watchers

Forks

Packages

No packages published