CS 386 Introduction to Database
Systems
Sample Databases
Text files of
commands to create databases in PostgreSQL ( If you have your own database, run
"psql -e < LibraryDB.sql" from your shell): LibraryDB, Spy, Sailors
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.pdx.edu –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/ 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:
