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

 1/*
 2REM
 3REM
 4REM Branch-ins.sql
 5REM
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "bank";
11
12INSERT INTO Branch 
13  VALUES('Downtown', 9000000, 'Brooklyn');
14
15INSERT INTO Branch 
16  VALUES('Redwood', 2100000, 'Palo Alto');
17
18INSERT INTO Branch 
19  VALUES('Perryridge', 1700000, 'Horseneck');
20
21INSERT INTO Branch 
22  VALUES('Mianus', 400000, 'Horseneck');
23
24INSERT INTO Branch 
25  VALUES('Round Hill', 8000000, 'Horseneck');
26
27INSERT INTO Branch 
28  VALUES('Pownal', 300000, 'Bennington');
29
30INSERT INTO Branch 
31  VALUES('North Town', 3700000, 'Rye');
32
33INSERT INTO Branch 
34  VALUES('Brighton', 7100000, 'Brooklyn');