Here are the basic tools for starting your local PostgreSQL server and building the monopoly database on Linux.
Start PostgreSQL on Linux using the following command:
psql
Create the monopoly database as follows.
Get a copy of the SQL command file that implements the basic Monopoly database, https://github.com/kvlinden-courses/cs262-code/blob/master/lab07/monopoly.sql.
\include filename.sql
This will automatically delete the old tables and build new ones. You can update the database by editing the script and re-running as needed.
You can display your relational tables by typing
\dt
.
You can quit PSQL by typing \q
.
This should work on all lab machines, but each machine keeps a separate database space, so you will need to rerun the build/load script on each new machine.