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

From ZCubes Wiki
Jump to navigation Jump to search
 1/*
 2REM
 3REM
 4REM Company-ins.sql
 5REM
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "companyb";
11
12INSERT INTO Company
13  VALUES('First Bank Corporation', 'Bryan');
14
15INSERT INTO Company
16  VALUES('Small Bank Corporation', 'Houston');
17
18INSERT INTO Company
19  VALUES('Minor Bank Corporation', 'Dallas');
20
21INSERT INTO Company
22  VALUES('Major Bank Corporation', 'Dallas');