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