Yurttas/PL/DBL/postgres/F/01/SPJ/Projects-ins.sql

 1/*
 2REM
 3REM
 4REM Projects-ins.sql
 5REM
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "spj";
11
12INSERT INTO Projects
13  VALUES('J01', 'Monitor', 'Boston');
14
15INSERT INTO Projects
16  VALUES('J02', 'Monitor', 'Portland');
17
18INSERT INTO Projects
19  VALUES('J03', 'Monitor', 'Denver');
20
21INSERT INTO Projects
22  VALUES('J04', 'Monitor', 'Houston');
23
24INSERT INTO Projects
25  VALUES('J05', 'Monitor', 'Dallas');
26
27INSERT INTO Projects
28  VALUES('J06', 'Monitor', 'Phoenix');
29
30INSERT INTO Projects
31  VALUES('J07', 'Monitor', 'Detroit');
32
33INSERT INTO Projects
34  VALUES('J08', 'Monitor', 'New York');
35
36INSERT INTO Projects
37  VALUES('J09', 'Monitor', 'Philadelphia');
38
39INSERT INTO Projects
40  VALUES('J10', 'CD-ROM', 'Boston');
41
42INSERT INTO Projects
43  VALUES('J11', 'CD-ROM', 'Houston');
44
45INSERT INTO Projects
46  VALUES('J12', 'CD-ROM', 'Dallas');
47
48INSERT INTO Projects
49  VALUES('J13', 'CD-ROM', 'New York');
50
51INSERT INTO Projects
52  VALUES('J14', 'CD-ROM', 'Portland');