ALTER TABLE _price_data ADD COLUMN currency_type int REFERENCES currency_type; UPDATE _price_data SET currency_type = "1" ; ALTER TABLE _price_data ADD COLUMN excluded boolean ; UPDATE _price_data SET excluded = false ; ALTER TABLE _currency_type_data ADD COLUMN format varchar(50); UPDATE _currency_type_data SET rate='1.00',format='$ %10.2f' where _table =1 ; insert into currency_type (id) values (2); insert into _currency_type_data (id,_table,name,rate,format,_start_t) values (2,2,'Dolares','2.95','U$D %10.2f',current_timestamp); insert into currency_type (id) values (3); insert into _currency_type_data (id,_table,name,rate,format,_start_t) values (3,3,'Euros','3.25','EUR %10.2f',current_timestamp);