
CREATE TEMPORARY TABLE New_ChartOfAccounts AS 
SELECT * FROM "Accounting"."ChartOfAccounts"
         WHERE "Accounting"."ChartOfAccounts".Cia = 'IS';
         
UPDATE New_ChartOfAccounts SET Cia = '00001';

INSERT INTO "Accounting"."ChartOfAccounts" 
       SELECT * FROM New_ChartOfAccounts;