已经从可以看懂照猫画虎😺，现在会考虑一些语法问题了，就是需要常用才能巩固🔒
#第一次进入等待15秒
#数据库启动中...
su - omm
gsql -r
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'),(200,'b'),(3,'c'),(300,'d'),(4,'e');
insert into store values (400,'f');
select * from store;
select * from store partition(store_p1);
select * from store partition(store_p3);
2.查看分区1上的数据
\d+ store;
select * from pg_partition;
3.重命名分区2
alter table store rename partition store_p1 to store_yc;
4.删除分区5
alter table store drop partition store_p4;
5.增加分区6
alter table store add partition store_p5;
6.在系统表pg_partition中查看分区信息
select * from pg_partition;
7.删除分区表
drop table store;
