1CREATE TABLE parent ( 2 a int 3); 4 5CREATE TABLE child () INHERITS (parent); 6 7CREATE TABLE grandchild () INHERITS (child); 8 9ALTER TABLE parent ADD COLUMN b serial; 10 11ALTER TABLE parent RENAME COLUMN b TO c; 12 13ALTER TABLE parent ADD CONSTRAINT a_pos CHECK (a > 0); 14 15CREATE TABLE part ( 16 a int 17) PARTITION BY RANGE (a); 18 19CREATE TABLE part1 PARTITION OF part FOR VALUES FROM (1) to (100); 20 21ALTER TABLE part ADD PRIMARY KEY (a); 22