ALTER TABLE cli_endereco ADD COLUMN observacao character varying(10000);
UPDATE cli_endereco SET observacao = '' WHERE observacao IS NULL;
ALTER TABLE cli_endereco ALTER COLUMN observacao SET NOT NULL;