PostgreSQL is the database that we use on production, and sometimes is is necessary to test stuff with it locally.
There are two main types of run with PostgreSQL:
To interactively inspect the local development database use our helper at web/bin/psql:
Commands can be run as usual:
web/bin/psql -c 'SELECT * FROM "Article";'
It uses PGPASSWORD is mentioned at: stackoverflow.com/questions/6405127/how-do-i-specify-a-password-to-psql-non-interactively


  1. OurBigBook Web development
  2. OurBigBook Web
  3. OurBigBook Project