Workflows & Procedures

Document to hold common tricks/procedures while working on the codebase

Accessing the Postgres Database from Docker Container

1. Go into the unilectives postgres terminal in the docker application

2. Inside the terminal run “psql -U postgres”. This will go inside the postgresql database as the user “postgres”. The -U is important here

3. Once inside the database, run “\c mydb” to go inside the mydb database that we use

4. Then just run the queries you want e.g. “SELECT course_code FROM unilectives.courses;”