Yurttas/PL/DBL/postgres/F/01/PC/PC-cre.sql
Revision as of 23:48, 4 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM REM PC-cre.sql REM REM: SELECT current_schema(); SET search_path to "pc"; CREATE TABLE PC(model VARCHAR...")
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));