首先查看PostgreSql 的版本号
select version();
由于我的终端经常超时,链接完成后设置一下超时时间
set statement_timeout to 30000000;
创建主表
CREATE TABLE public.webworkordertest
(
daytime timestamp without time zone,
cgi text
)PARTITION BY RANGE (daytime);
创建分区表继承主表
CREATE TABLE webworkordertest_20190822 PARTITION OF webworkordertest
FOR VALUES FROM ('2019-08-22') TO ('2019-08-23');
正常插入数据
insert into webworkordertest values('2019-08-22 00:00:00','12345');
插入非正常数据
insert into webworkordertest values('2019-08-24 00:00:00','12345');