Script started on Thu Sep  6 13:33:29 2001
[marlowe Misc]$ psql
Password: 
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

sc42405=# \set ECHO all
sc42405=# \dt
No relations found.
sc42405=# \i homework1.sql
CREATE TABLE CDs (
	author VARCHAR(30), 
	title VARCHAR(50), 
	year SMALLINT, 
	company VARCHAR(50), 
	rating SMALLINT 
		CHECK (rating >=0 and rating <= 10),
	list_price MONEY,
	actual_price MONEY
);
CREATE
INSERT INTO CDs VALUES (
	'Barenaked Ladies', 'Rock Spectacle', 1996, 'Reprise Records', 8, '$20.00', '$15.99'
);
INSERT 22501 1
INSERT INTO CDs VALUES (
	'U2', 'All that you can\'t leave behind', 2000, 'Universal International Music', 
	8, '$22.00', '$16.99'
);
INSERT 22502 1
INSERT INTO CDs VALUES (
	'Grant Lee Philips', 'Mobilize', 2001, 'Zoe Records', 9, '$20.00', '$20.00'
); 
INSERT 22503 1
INSERT INTO CDs VALUES (
	'ABBA', 'Greatest Hits', 1992, 'Polygram Records', 9, '$20.00', '$10.99'
);
INSERT 22504 1
INSERT INTO CDs VALUES (
	'Author2000', 'Title2000', 2000, 'Company2000', 2, '$2000.00', '$0.20'
); 
INSERT 22505 1
SELECT title, author FROM CDs WHERE year = 2000;
              title              |   author   
---------------------------------+------------
 All that you can't leave behind | U2
 Title2000                       | Author2000
(2 rows)

DROP TABLE CDs;
DROP
 	
sc42405=# \dt
No relations found.
sc42405=# \q
[marlowe Misc]$ exit

script done on Thu Sep  6 13:35:53 2001

script done on Thu Sep  6 13:35:53 2001