ALTER TABLE public.book
     RENAME COLUMN visible TO visible_new;

ALTER TABLE public.book
     ADD COLUMN visible boolean;

UPDATE public.book SET visible = true where visible_new = 1::bit(1);
UPDATE public.book SET visible = false where visible_new = 0::bit(1);

ALTER TABLE public.book
     DROP COLUMN IF EXISTS visible_new;