UPDATE costs SET “ID”=10000+nextval(‘”costs_ID_seq”‘);
ALTER SEQUENCE “costs_ID_seq” RESTART WITH 1;
UPDATE costs SET “ID”=nextval(‘”costs_ID_seq”‘);
SQL development & Database design & PostgreSQL & Linux
UPDATE costs SET “ID”=10000+nextval(‘”costs_ID_seq”‘);
ALTER SEQUENCE “costs_ID_seq” RESTART WITH 1;
UPDATE costs SET “ID”=nextval(‘”costs_ID_seq”‘);