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

浪淘沙5个月前 (11-21)数据库117

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));

返回列表

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

ALTER TABLE public.qx SET SCHEMA qy;...

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

SELECT datname AS database_name, oid ...

一、创建 jy schemaCREATE SCHEMA IF NOT EXISTS jy; 验证： SELECT schema_na...

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

xxt.red 校校通