
CREATE TABLE cities (
   name            text
   , population      int
   , altitude        int     -- in feet
);
     
CREATE TABLE capitals (
   state           char(2)
) INHERITS (cities);

insert into cities values('New York City', 8175133, 33);
insert into cities values('Syracuse', 145170, 380);
insert into capitals values('Albany', 97856, 312, 'NY');

