postgre 序列字段操作命令集合

ALTER table tablename alter column index set DEFAULT nextval('tablename_index_seq');

设置自增序列为表内最大的ID值

select setval('xxx_id_seq', max(id)) from tbname;

查看指定序列的当前的值

SELECT nextval('xxx_id_seq ');

重置序列起始值为 1

alter sequence xxx_id_seq restart with 1;

重置序列

TRUNCATE tableName RESTART IDENTITY;

清空表数据

TRUNCATE tablename questions CASCADE;

清除所有的记录，并且索引号从 0 开始

TRUNCATE tablename questions RESTART IDENTITY CASCADE;