1、创建自增序列
CREATE SEQUENCE table_name_id_seq START 1;
2、设置字段默认值
字段默认值中设置 nextval(‘table_name_id_seq’)
![在这里插入图片描述](https://img-blog.csdnimg.cn/f091055160be45bd8eae2b2ea6cd20f4.png)
3、常用查询
select * from information_schema.sequences where sequence_schema = 'public';
select currval('table_name_id_seq');
select nextval('table_name_id_seq');