DBMS PROGRAMMING WITH PYTHON AND POSTGRESQL

Here are the commands you can run to perform actions

1. First Write Your Commands in commands Directory if you want own table structure

To connect with database

python connect.py

To Create New Table

1. python create_table.py 

To Insert the data

1. python insert_data.py student roll_no 'full_name' age 'dob' course_id
2. python insert_data.py course "Course Name"
3. python insert_data.py teacher "full_name" "qualificaition" course_id

To get data from particular table

1. python get_data.py table_name

To delete data from particular table

1. python delete_data.py table_name id_to_delete

To Update data from particular table

1. python update_data.py "New Course Name" id_to_update

Reference Guide :

1. https://www.postgresqltutorial.com/postgresql-python/