Setup

You already have a Postgres container named pg running. Give Inkwell its own database:

docker exec -it pg psql -U postgres -c "CREATE DATABASE inkwell;"

Run a file against it (do this for each migration, in order):

docker exec -i pg psql -U postgres -d inkwell < data/migrations/sql/001_users_and_posts.sql

Open an interactive session:

docker exec -it pg psql -U postgres -d inkwell

Inside psql: \dt lists tables, \d posts describes one, \h ALTER TABLE shows the syntax for a command, \q quits. (If your container's superuser isn't postgres, swap the -U value.)