CREATE SEQUENCE public.my_book_seq;

SELECT setval('public.my_book_seq', (SELECT max(id) FROM public.book));

ALTER TABLE public.book ALTER COLUMN id SET DEFAULT nextval('public.my_book_seq'::regclass);