Interacting with Postgres

Connecting to the Development Database

It is useful to be able to query the development database while the app is running to debug or validate results.

1. Install Postgres on your local machine by following the instructions here.

2. In your terminal of choice, run

psql -h 127.0.0.1 -p 5433 -U postgres postgres

The password should also be postgres.

3. Check that pe_dev is a table by running \l.

4. Connect to pe_dev by using

\c pe_dev

You should be able to run queries as you would in any other db console. Make sure you add ; at the end of every query!