Yurttas/PL/DBL/postgres/F/01/Bank/v01.sql

 1/*
 2REM
 3REM v01.sql
 4REM
 5REM Consider a view consisting of
 6REM branch names and the names of customers.
 7REM
 8*/
 9
10SELECT current_schema();
11SET search_path to "bank";
12
13CREATE VIEW AllCustomer
14  AS (SELECT branchname, customername
15      FROM Depositor)
16     UNION
17     (SELECT branchname, customername
18      FROM Borrower);