CREATE INDEX p2_val_idx_1 ON p2 USING hash (val);

WARNING: hash indexes are not WAL-logged and their use is discouraged

CREATE INDEX p2_val_id_idx ON p2 (val, id);

CREATE INDEX p2_val_idx2 ON p2 (val COLLATE "ja_JP");

CREATE INDEX p2_val_idx2 ON p2 (val COLLATE "C");

CREATE INDEX p2_val_idx3 ON p2 (val varchar_ops);

CREATE INDEX p2_val_idx4 ON p2 (val DESC NULLS LAST);

CREATE INDEX p2_val_idx5 ON p2 (val NULLS FIRST);

CREATE TABLE s1.t4 (LIKE s1.t1 INCLUDING ALL);

CREATE TABLE s2.t1 (LIKE s1.t1 INCLUDING ALL);

CREATE TABLE s1.p1 (LIKE s1.t1 INCLUDING ALL);

CREATE UNIQUE INDEX p1_parent ON s1.p1 USING btree (c4 COLLATE "ja_JP" varchar_ops ASC NULLS LAST, (c1 * 2 < 100)) WHERE c1 < 10;

CREATE UNIQUE INDEX p1_parent ON s1.p1 USING btree (c4 COLLATE "C" varchar_ops ASC NULLS LAST, (c1 * 2 < 100)) WHERE c1 < 10;

CREATE TABLE s1.p2 (LIKE s1.t1 INCLUDING ALL);

CREATE TABLE s1.p1c1 (LIKE s1.p1 INCLUDING ALL, CHECK (c1 <= 100)) INHERITS(s1.p1);

NOTICE: merging column "c1" with inherited definition

CREATEINDEXp2_ununi_id_val_idxON p2 (val);

CREATEINDEXp2_val_idx_1ON p2 USING hash (val);

CREATEINDEXp2_val_id_idxON p2 (val, id);

CREATEINDEXp2_val_idx2ON p2 (val COLLATE"ja_JP");

CREATEINDEXp2_val_idx2ON p2 (val COLLATE"C");

CREATEINDEXp2_val_idx3ON p2 (val varchar_ops);

CREATEINDEXp2_val_idx4ON p2 (valDESC NULLS LAST);

CREATEINDEXp2_val_idx5ON p2 (val NULLS FIRST);

CREATETABLEs1.t4 (LIKEs1.t1 INCLUDING ALL);

CREATETABLEs2.t1 (LIKEs1.t1 INCLUDING ALL);

CREATETABLEs1.p1 (LIKEs1.t1 INCLUDING ALL);

CREATEUNIQUE INDEXp1_parentONs1.p1 USING btree (c4 COLLATE"ja_JP" varchar_opsASC NULLS LAST, (c1*2<100))WHERE c1<10;

CREATEUNIQUE INDEXp1_parentONs1.p1 USING btree (c4 COLLATE"C" varchar_opsASC NULLS LAST, (c1*2<100))WHERE c1<10;

CREATETABLEs1.p2 (LIKEs1.t1 INCLUDING ALL);

CREATETABLEs1.p1c1 (LIKEs1.p1 INCLUDING ALL,CHECK (c1<=100)) INHERITS(s1.p1);

CREATETABLEs1.p1c2 (LIKEs1.p1 INCLUDING ALL,CHECK (c1>100AND c1<=200)) INHERITS(s1.p1);