CREATE SCHEMA bob; | |
CREATE TABLE bob.country | |
( | |
id int, | |
name varchar(20) | |
); | |
insert into bob.country | |
values (1, 'India'); | |
insert into bob.country | |
values (2, 'Russia'); | |
insert into bob.country | |
values (3, 'USA'); | |
CREATE SCHEMA alice; | |
CREATE TABLE alice.country | |
( | |
id int, | |
name varchar(20) | |
); | |
insert into alice.country | |
values (4, 'Italy'); | |
insert into alice.country | |
values (5, 'Greece'); | |
insert into alice.country | |
values (6, 'China'); | |
insert into alice.country | |
values (7, 'Japan'); |