openGauss每日一练第 8天|分区表使用

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

create table store
(
        c1 int,
        c2 CHAR(2)
)
partition by range (c1)
(
        partition store_p0 values less than (50),
        partition store_p1 values less than (100),
        partition store_p2 values less than (150),
        partition store_p3 values less than (200),
        partition store_p4 values less than (250)
);


insert into store values (1, 'a'), (51, 'b'), (101, 'c'),(151, 'd'),(201, 'e');
复制

2.查看分区1上的数据

select * from store partition(store_p0);
复制

3.重命名分区2

alter table store rename partition store_p1 to store_p1_1;
复制

4.删除分区5

alter table store drop partition store_p4;
复制

5.增加分区6

alter table store add partition store_p5 values less than (300);
复制

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

\d+ store;
select * from pg_partition;
复制

7.删除分区表

drop table store;
复制