Yurttas/PL/DBL/postgres/F/01/PC/PC-cre.sql

 1/*
 2REM
 3REM
 4REM PC-cre.sql
 5REM
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "pc";
11
12CREATE TABLE PC(model VARCHAR(6) NOT NULL,
13                speed INTEGER NOT NULL,
14                ram INTEGER NOT NULL,
15                hd FLOAT NOT NULL,
16                cd VARCHAR(4) NOT NULL,
17                price INTEGER NOT NULL,
18   PRIMARY KEY (model));