postgresql重置序列起始值的操作

-- 序列重置到1000
alter sequence sequence_name restart with 1000
-- 验证
SELECT nextval('sequence_name');

 ERROR: duplicate key value violates unique constraint "tableName_pkey"
DETAIL: Key (id)=(1) already exists.

alter sequence xxx_id_seq restart with 1

SELECT nextval('xxx_id_seq ');

TRUNCATE tableName RESTART IDENTITY;

TRUNCATE tablename questions CASCADE;

TRUNCATE tablename questions RESTART IDENTITY CASCADE;

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