CS 386 Introduction to Database
Systems
Sample Database
A text file of commands to create the
database in PostgreSQL ( If you have your own
database, run "psql -e < SpyDB.sql"
from your shell): Spy . You may need to customize null values.
How to Access these databases on PostgreSQL
You can access an installation of PostgreSQL
via a command line or GUI interface. Both are explained on http://www.cat.pdx.edu/web/database-services.html
. On that page you can also learn how to get your own Postgres
database on the CECS server. In order to access the shared copies of the
databases that we will all use, there are a few changes to those directions.
- From
any cat-managed machine, get to the command line interface with
% psql –h db.cecs –U introdb_readonly introdb_X
where X is
one of {spy, sailors, library}, and use the password introdb .
- Access
the GUI from any browser via https://www.cat.pdx.edu/phpPgAdminIntroDb/
. Note that this is not the same as
the utility phpPgAdmin – it has been changed
slightly. Enter the user / password introdb_readonly / introdb . To get past the first page of
the GUI, click on the name of the database you want to access.
Technical Information
PostgreSQL information:
Other Resources: