postgresql 取消id主键和自增后,添加完数据,又恢复自增
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));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...