分类：批量修改sequences

2020
12-29

pgsql批量修改sequences的start方式

修改为指定值DO$$DECLARErrecord;BEGINFORrINSELECTsequence_nameFROMinformation_schema."sequences"LOOPEXECUTE'ALTERSEQUENCE'||r.sequence_name||'restartWITH10000';ENDLOOP;END$$;根据表的id修改DO$$DECLARErrecord;start_valueinteger:=0;BEGINFORrINSELECTtablename||'_id_seq'ASsequence_name,tablenameFROMpg_tablesWHEREschemaname='public'LOOPEXECUTE'SELECTmax(id)+1AS... 继续阅读 >