ALTER TABLE par_producao
  ADD COLUMN exibe_botao_finaliza character varying(1);
  
UPDATE par_producao SET exibe_botao_finaliza = 'S' WHERE exibe_botao_finaliza IS NULL;
 
ALTER TABLE par_producao
   ALTER COLUMN exibe_botao_finaliza SET NOT NULL;