PG数据库-改所有以seq_djcode开头的序列为循环序列

需求： 给所有以seq_djcode开头的序列设置CYCLE属性

 

执行SQL语句：

--是将所有seq_djcode开头的序列设置为CYCLE属性

DO $$
DECLARE
r RECORD;
BEGIN
FOR r IN SELECT sequence_name FROM information_schema.sequences WHERE sequence_name LIKE 'seq_djcode%' LOOP
EXECUTE format('ALTER SEQUENCE %I CYCLE;', r.sequence_name);
END LOOP;
END $$;