ALTER TABLE public.pet_agenda ADD COLUMN status character varying(1); UPDATE pet_agenda SET status = 'A' WHERE status IS NULL; ALTER TABLE public.pet_agenda ALTER COLUMN status SET NOT NULL;