- 创建序列
CREATE SEQUENCE if not exists test_mergetable_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 999999999
START 1
CACHE 1;
//或者:
create sequence if not exists test_mergetable_id_seq increment by 1 minvalue 1 no maxvalue start with 1;
- 指定序列(给表的主键指定创建好的序列)
alter table test_mergetable alter column "i_id" set default nextval('test_mergetable_id_seq');
- 设置序列自增长从当前最大值开始
SELECT setval('test_mergetable_id_seq', (SELECT MAX(i_id) FROM test_mergetable));
alter sequence test_mergetable_id_seq start with 12;
- 删除序列
drop sequence IF EXISTS test_mergetable_id_seq
- 查看序列
SELECT nextval('test_mergetable_id_seq')
- 获得PostgreSQL序列的当前值(最后值)
select * from seq_mail_id ;
结果表中last_value这个值就是你想要的