CREATE TABLE bids auction_id varchar 254 not null data text biddate da

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');