Yurttas/PL/DBL/postgres/F/01/Company-B/q13.sql

 1/*
 2REM
 3REM q13.sql
 4REM
 5REM Modify the database so that 'Jones' now employee in 'Newtown'.
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "companyb";
11
12UPDATE employee
13SET city = 'Newtown'
14WHERE employeename = 'Jones';