ALTER TABLE par_entrada
  ADD COLUMN replica_duplicata_pagar character varying(1);

UPDATE par_entrada SET replica_duplicata_pagar = 'N' WHERE replica_duplicata_pagar IS NULL;

ALTER TABLE par_entrada
  ALTER COLUMN replica_duplicata_pagar SET NOT NULL;