create schema myschm; create table myschm.t1 (num integer, data text); insert into myschm.t1 values(1, 'myschm'); insert into myschm.t1 values(2, 'myschm');