src/test/modules/test_ddl_deparse/sql/alter_table.sql

CREATE TABLE parent (
	a int
);

CREATE TABLE child () INHERITS (parent);

CREATE TABLE grandchild () INHERITS (child);

ALTER TABLE parent ADD COLUMN b serial;

ALTER TABLE parent RENAME COLUMN b TO c;

ALTER TABLE parent ADD CONSTRAINT a_pos CHECK (a > 0);

CREATE TABLE part (
	a int
) PARTITION BY RANGE (a);

CREATE TABLE part1 PARTITION OF part FOR VALUES FROM (1) to (100);

ALTER TABLE part ADD PRIMARY KEY (a);