postgresql 取消id主键和自增后，添加完数据，又恢复自增

浪淘沙8个月前 (11-21)数据库182

ALTER TABLE qy_gw ALTER COLUMN id SET DEFAULT nextval('qy_gw_id_seq');
SELECT setval('qy_gw_id_seq', (SELECT MAX(id) FROM qy_gw));

返回列表

CREATE SEQUENCE stu_id_seq SELECT setval( 'stu_id_seq', &nbs...

delete from article_author;dbcc checkident('article_author',reseed,0)...

EXEC sys.sp_addextendedproperty @name=N'MS_Description',@level1type=N'TABLE...

DROP TABLE IF EXISTS "public"."zj_gg"; CREATE SEQUENCE...

https://blog.csdn.net/h1773655323/article/details/142454517...

SELECT format( 'SELECT setval(%L, COALESCE((SELE...

xxt.red 校校通