Yurttas/PL/DBL/postgres/F/01/Bank/Depositor-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 Depositor-ins.sql REM REM: SELECT current_schema(); SET search_path to "bank"; INSERT INTO Deposito...")
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);