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