Yurttas/PL/DBL/postgres/F/01/Company-B/Employee-ins.sql
Revision as of 00:43, 5 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM REM Employee-ins.sql REM REM: SELECT current_schema(); SET search_path to "companyb"; INSERT INTO Emplo...")
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');