----------------------------------------------------------------------------------------
-- CHECK.SQL
--
-- SQL statements for displaying example data into the CAP2 database
-- 
-- Derived from the CAP examples in _Database Principles, Programming, and Performance_, 
--   Second Edition by Patrick O'Neil and Elizabeth O'Neil
-- 
-- Modified by Alan G. Labouseur
-- 
-- Tested on Postgres 8.3
---------

-- Connect to your Postgres server and set the active database to CAP2.  Then . . .

select *
from customers;

select *
from agents;

select *
from products;

select *
from orders;