ALTER TABLE public.book
     RENAME COLUMN visible TO visible_new;

ALTER TABLE public.book
     ADD COLUMN visible bit(1);

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

ALTER TABLE public.book
     DROP COLUMN IF EXISTS visible_new;