0-add-column-responsaveisomisso-.sql 412 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12

DO $$ 
    BEGIN
        BEGIN
            ALTER table par.responsaveisomisso ADD COLUMN carga VARCHAR(255);
            comment on column par.responsaveisomisso.carga is 'Informa os estágios das cargas 1-CREDITO 2-EXTRATOCONTA 3-CREDITOVIRADEBITO';
        	EXCEPTION
            WHEN duplicate_column THEN RAISE NOTICE 'column carga already exists in par.responsaveisomisso.carga';
        END;
    END;
$$