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

From ZCubes Wiki
Jump to navigation Jump to search
 1/*
 2REM
 3REM
 4REM Depositor-ins.sql
 5REM
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "bank";
11
12INSERT INTO Depositor
13  VALUES('Downtown', 101, 'Johnson', 500);
14
15INSERT INTO Depositor
16  VALUES('Mianus', 215, 'Smith', 700);
17
18INSERT INTO Depositor
19  VALUES('Perryridge', 102, 'Hayes', 400);
20
21INSERT INTO Depositor
22  VALUES('Round Hill', 305, 'Turner', 350);
23
24INSERT INTO Depositor
25  VALUES('Perryridge', 201, 'Williams', 900);
26
27INSERT INTO Depositor
28  VALUES('Redwood', 222, 'Lindsay', 700);
29
30INSERT INTO Depositor
31  VALUES('Brighton', 217, 'Green', 750);
32
33INSERT INTO Depositor
34  VALUES('Downtown', 105, 'Green', 850);