- Install python (this program uses 3.11.8)
- Install psycopg2 with
pip install psycopg2
- Run postgres
- Create
students
table in postgres with
CREATE TABLE students(
student_id SERIAL PRIMARY KEY,
first_name VARCHAR(255) NOT NULL,
last_name VARCHAR(255) NOT NULL,
email VARCHAR(255) NOT NULL UNIQUE,
enrollment_date DATE
);
- Add login info to
operations.py
- Navigate to the project folder
- Run
py main.py
in the terminal