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

 1/*
 2REM
 3REM
 4REM Employee-ins.sql
 5REM
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "companyb";
11
12INSERT INTO Employee
13  VALUES('Jeremy', '123-C Front', 'Austin');
14
15INSERT INTO Employee
16  VALUES('Charles', '55 Main', 'Austin');
17
18INSERT INTO Employee
19  VALUES('Jamie', '55 Main', 'Austin');
20
21INSERT INTO Employee
22  VALUES('Casey', '251 Main', 'Austin');
23
24INSERT INTO Employee
25  VALUES('Thomas', '158 Main', 'Houston');
26
27INSERT INTO Employee
28  VALUES('Anthony', '37 North Star', 'Houston');
29
30INSERT INTO Employee
31  VALUES('Benjamin', '414 Union', 'Houston');
32
33INSERT INTO Employee
34  VALUES('Sara', '816 Back', 'Dallas');
35
36INSERT INTO Employee
37  VALUES('David', '816 Back', 'Dallas');
38
39INSERT INTO Employee
40  VALUES('Michael', '816 Back', 'Dallas');
41
42INSERT INTO Employee
43  VALUES('Jennifer', '20 Second', 'Dallas');
44
45INSERT INTO Employee
46  VALUES('Laura', '20 Second', 'Dallas');