openGauss每日一练第8天 openGauss分区表

一.创建一个含有5个分区的范围分区表store，在每个分区中插入记录
1.创建一个含有5个分区的范围分区表store

create table store
(
        c1 int,
        c2 CHAR(2)
)
partition by range (c1)
(
        partition store_table_p0 values less than (50),
        partition store_table_p1 values less than (100),
        partition store_table_p2 values less than (150),
	partition store_table_p3 values less than (200),
        partition store_table_p4 values less than (250)
);

2.创建一个含有5个分区的范围分区表store

insert into store values(1,'1');
insert into store values(50,'2');
insert into store values(100,'3');
insert into store values(150,'4');
insert into store values(200,'5');

二.查看分区1上的数据

select * from store partition(store_table_p0);

三.重命名分区2

alter table store rename partition store_table_p1 to store_table_p1_1;

四.删除分区5

alter table store drop partition store_table_p4;

五.增加分区6

alter table store add partition store_table_p5 values less than (300);

六.在系统表pg_partition中查看分区信息

\d+ store;
select * from pg_partition;

七.删除分区表

drop table store;