本篇文章主要介绍了" pg 10多级分区表（range_list）配置查询"，主要涉及到方面的内容，对于其他数据库感兴趣的同学可以参考一下：
-- define partitioned table: t_range_listcreate table t_range_list(id bigserial,...
create table t_range_list_0_201702 partition of t_range_list_0 (id primary key, tenant_id , crt_time ) for values from ('2017-02-01') to ('2017-03-01');
create table t_range_list_0_201703 partition of t_range_list_0 (id primary key, tenant_id , crt_time ) for values from ('2017-03-01') to ('2017-04-01');
create table t_range_list_0_201704 partition of t_range_list_0 (id primary key, tenant_id , crt_time ) for values from ('2017-04-01') to ('2017-05-01');
create table t_range_list_0_201705 partition of t_range_list_0 (id primary key, tenant_id , crt_time ) for values from ('2017-05-01') to ('2017-06-01');
create table t_range_list_0_201706 partition of t_range_list_0 (id primary key, tenant_id , crt_time ) for values from ('2017-06-01') to ('2017-07-01');
create table t_range_list_0_201707 partition of t_range_list_0 (id primary key, tenant_id , crt_time ) for values from ('2017-07-01') to ('2017-08-01');
create table t_range_list_0_201708 partition of t_range_list_0 (id primary key, tenant_id , crt_time ) for values from ('2017-08-01') to ('2017-09-01');
create table t_range_list_0_201709 partition of t_range_list_0 (id primary key, tenant_id , crt_time ) for values from ('2017-09-01') to ('2017-10-01');
create table t_range_list_0_201710 partition of t_range_list_0 (id primary key, tenant_id , crt_time ) for values from ('2017-10-01') to ('2017-11-01');
create table t_range_list_0_201711 partition of t_range_list_0 (id primary key, tenant_id , crt_time ) for values from ('2017-11-01') to ('2017-12-01');
create table t_range_list_0_201712 partition of t_range_list_0 (id primary key, tenant_id , crt_time ) for values from ('2017-12-01') to ('2018-01-01');
-- t_range_list_1
create table t_range_list_1_201701 partition of t_range_list_1 (id primary key, tenant_id , crt_time ) for values from ('2017-01-01') to ('2017-02-01');
