1 2 3 4 5 6 7 8
CREATE TABLE bids ( auction_id varchar(254) not null, data text, biddate date not null ) PARTITION BY RANGE (biddate); CREATE TABLE bids_y2019m02d20 PARTITION OF bids FOR VALUES FROM ('2019-02-20') TO ('2019-02-21');