openGauss每日一练第 8 天 |学习openGauss分区表

自己安装的openGauss环境
启动openGauss
gs_ctl -D /gauss/data/db1/ start
登录openGauss
gsql -d postgres -p 26000 -r

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

create table store(c1 int)
partition by range (c1)
(partition p0 values less than (50),partition p1 values less than (100),partition p2 values less than (150),partition p3 values less than (200),partition p4 values less than (250));
\d+ store;

insert into store(c1) values(10),(60),(110),(160),(210);
select * from store;

2.查看分区1上的数据

select * from store partition(p0);

3.重命名分区2

alter table store rename partition p1 to p1_1;

4.删除分区5

alter table store drop partition p4;

5.增加分区6

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

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

select * from pg_partition;

7.删除分区表

drop table store;