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

 1/*
 2REM
 3REM
 4REM Works-ins.sql
 5REM
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "companyb";
11
12INSERT INTO Works
13  VALUES('Jeremy', 'First Bank Corporation', 100000);
14
15INSERT INTO Works
16  VALUES('Charles', 'First Bank Corporation', 40000);
17
18INSERT INTO Works
19  VALUES('Jamie', 'First Bank Corporation', 40000);
20
21INSERT INTO Works
22  VALUES('Casey', 'First Bank Corporation', 30000);
23
24INSERT INTO Works
25  VALUES('Thomas', 'Small Bank Corporation', 60000);
26
27INSERT INTO Works
28  VALUES('Anthony', 'Small Bank Corporation', 60000);
29
30INSERT INTO Works
31  VALUES('Benjamin', 'Small Bank Corporation', 80000);
32
33INSERT INTO Works
34  VALUES('Sara', 'Minor Bank Corporation', 50000);
35
36INSERT INTO Works
37  VALUES('David', 'Minor Bank Corporation', 40000);
38
39INSERT INTO Works
40  VALUES('Michael', 'Major Bank Corporation', 30000);
41
42INSERT INTO Works
43  VALUES('Jennifer', 'Major Bank Corporation', 90000);