Yurttas/PL/DBL/postgres/F/01/Bank/Borrower-ins.sql

 1/*
 2REM
 3REM
 4REM Borrower-ins.sql
 5REM
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "bank";
11
12INSERT INTO Borrower 
13  VALUES('Downtown', 17, 'Jones', 1000);
14
15INSERT INTO Borrower 
16  VALUES('Redwood', 23, 'Smith', 2000);
17
18INSERT INTO Borrower 
19  VALUES('Perryridge', 15, 'Hayes', 1500);
20
21INSERT INTO Borrower 
22  VALUES('Mianus', 93, 'Curry', 500);
23
24INSERT INTO Borrower 
25  VALUES('Round Hill', 11, 'Turner', 900);
26
27INSERT INTO Borrower 
28  VALUES('Pownal', 29, 'Williams', 1200);
29
30INSERT INTO Borrower 
31  VALUES('North Town', 16, 'Adams', 1300);
32
33INSERT INTO Borrower 
34  VALUES('Downtown', 18, 'Johnson', 2000);
35
36INSERT INTO Borrower 
37  VALUES('Perryridge', 25, 'Glenn', 2500);
38
39INSERT INTO Borrower 
40  VALUES('Brighton', 10, 'Brooks', 2200);