Postgresql restart id sequence identity

sql

SELECT MAX(id) FROM "Content";

SELECT nextval('"Content_id_seq"'::text);


BEGIN;
-- protect against concurrent inserts while you update the counter
LOCK TABLE "Content" IN EXCLUSIVE MODE;
-- Update the sequence
SELECT setval('"Content_id_seq"', COALESCE((SELECT MAX(id)+1 FROM "Content"), 1), false);
COMMIT;