Yurttas/PL/DBL/postgres/F/01/Company-A/Project-ins.sql

 1/*
 2REM
 3REM
 4REM Project-ins.sql
 5REM
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "companya";
11
12INSERT INTO Project
13  VALUES('ProductX', '1', 'Bellaire', '5');
14
15INSERT INTO Project
16  VALUES('ProductY', '2', 'Sugarland', '5');
17
18INSERT INTO Project
19  VALUES('ProductZ', '3', 'Houston', '5');
20
21INSERT INTO Project
22  VALUES('Computerization', '10', 'Stafford', '4');
23
24INSERT INTO Project
25  VALUES('Reorganization', '20', 'Houston', '1');
26
27INSERT INTO Project
28  VALUES('Newbenefits', '30', 'Stafford', '4');