Yurttas/PL/DBL/postgres/F/01/PC/Laptop-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 Laptop-cre.sql REM REM: SELECT current_schema(); SET search_path to "pc"; CREATE TABLE Laptop(model...")
(diff) ← Older revision | Latest revision (diff) | Newer revision β†’ (diff)
 1/*
 2REM
 3REM
 4REM Laptop-cre.sql
 5REM
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "pc";
11
12CREATE TABLE Laptop(model VARCHAR(6) NOT NULL,
13                    speed INTEGER NOT NULL,
14                    ram INTEGER NOT NULL,
15                    hd FLOAT NOT NULL,
16                    screen FLOAT NOT NULL,
17                    price INTEGER NOT NULL,
18        PRIMARY KEY(model));