----删除前先解除 id 对该序列的依赖
ALTER TABLE public.biz_device ALTER COLUMN id SET DEFAULT null;
DROP SEQUENCE IF EXISTS device_id_seq;
SELECT MAX(id) FROM public.biz_device;
---- id_max 即 id 目前的最大值,可写为1,可通过 “SELECT MAX(id) FROM tablename” 得到
CREATE SEQUENCE biz_device_id_seq START WITH id_max;
ALTER TABLE public.biz_device ALTER COLUMN id SET DEFAULT nextval('biz_device_id_seq'::regclass);