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

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