序列操作

-- 创建序列
CREATE SEQUENCE globel_number_sequence INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
-- 下一个值
select nextval('globel_number_sequence');
-- 当前值
select currval('globel_number_sequence');

-- 修改起始值
alter sequence globel_number_sequence restart with 1000