Here are the basic tools for starting your local PostgreSQL server and building the monopoly database on Linux.

  1. Start PostgreSQL on Linux using the following command:

    psql
  2. 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.

    1. Load/run the script from within PSQL by typing:
      \include filename.sql
    2. 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.

  3. 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.