Yurttas/PL/DBL/postgres/F/01/Company-B/Manages-ins.sql

From ZCubes Wiki
Jump to navigation Jump to search
 1/*
 2REM
 3REM
 4REM Manages-ins.sql
 5REM
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "companyb";
11
12INSERT INTO Manages
13  VALUES('Jeremy', NULL);
14
15INSERT INTO Manages
16  VALUES('Charles', 'Jeremy');
17
18INSERT INTO Manages
19  VALUES('Jamie', 'Jeremy');
20
21INSERT INTO Manages
22  VALUES('Casey', 'Jeremy');
23
24INSERT INTO Manages
25  VALUES('Thomas', 'Benjamin');
26
27INSERT INTO Manages
28  VALUES('Anthony', 'Benjamin');
29
30INSERT INTO Manages
31  VALUES('Benjamin', NULL);
32
33INSERT INTO Manages
34  VALUES('Sara', NULL);
35
36INSERT INTO Manages
37  VALUES('David', 'Sara');
38
39INSERT INTO Manages
40  VALUES('Michael', 'Jennifer');
41
42INSERT INTO Manages
43  VALUES('Jennifer', NULL);