Lab realized as a student at ECN. This app is a python CLI (command line interface) to query a PostgreSQL database. https://github.com/DricomDragon/PythonPostgresLab
Jovian (Netbook)
5c91993bdd
Script to create database
|
6 years ago | |
|---|---|---|
| SQL | 6 years ago | |
| .gitignore | 6 years ago | |
| README.md | 6 years ago | |
| app_dispatcher.py | 6 years ago | |
| connect.py | 6 years ago |
README.md
PythonPostgresLab
A CLI (Command Line Interface) written in python to query a PostgreSQL database. Lab realized as a student at Ecole Centrale de Nantes (ECN).
Postgres
Install postgreSQL :
sudo apt install postgresql
Connect with postgres profile :
sudo su postgres
Create the database :
psql -f SQL/create_db.sql postgres
Populate database with tables :
psql -d logistics -f SQL/create_tables.sql postgres