1/*
2REM
3REM
4REM Product-ins.sql
5REM
6REM
7*/
8
9SELECT current_schema();
10SET search_path to "pc";
11
12INSERT INTO Product
13 VALUES('A', '1001', 'pc');
14
15INSERT INTO Product
16 VALUES('A', '1002', 'pc');
17
18INSERT INTO Product
19 VALUES('A', '1003', 'pc');
20
21INSERT INTO Product
22 VALUES('B', '1004', 'pc');
23
24INSERT INTO Product
25 VALUES('B', '1006', 'pc');
26
27INSERT INTO Product
28 VALUES('B', '3002', 'printer');
29
30INSERT INTO Product
31 VALUES('B', '3004', 'printer');
32
33INSERT INTO Product
34 VALUES('C', '1005', 'pc');
35
36INSERT INTO Product
37 VALUES('C', '1007', 'pc');
38
39INSERT INTO Product
40 VALUES('D', '1008', 'pc');
41
42INSERT INTO Product
43 VALUES('D', '1009', 'pc');
44
45INSERT INTO Product
46 VALUES('D', '1010', 'pc');
47
48INSERT INTO Product
49 VALUES('D', '2001', 'laptop');
50
51INSERT INTO Product
52 VALUES('D', '2002', 'laptop');
53
54INSERT INTO Product
55 VALUES('D', '2003', 'laptop');
56
57INSERT INTO Product
58 VALUES('D', '3001', 'printer');
59
60INSERT INTO Product
61 VALUES('D', '3003', 'printer');
62
63INSERT INTO Product
64 VALUES('E', '2004', 'laptop');
65
66INSERT INTO Product
67 VALUES('E', '2008', 'laptop');
68
69INSERT INTO Product
70 VALUES('F', '2005', 'laptop');
71
72INSERT INTO Product
73 VALUES('G', '2006', 'laptop');
74
75INSERT INTO Product
76 VALUES('G', '2007', 'laptop');
77
78INSERT INTO Product
79 VALUES('H', '3005', 'printer');
80
81INSERT INTO Product
82 VALUES('I', '3006', 'printer');