Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
1 Odgovori
3102 Prikazi

I have price1 in product.product, And I create new field price2 ,then I want to copy  price1 value to price2

There are thousands of price1 and I tried erppeek ,but it seems too slow

Avatar
Opusti
Best Answer

Hi Chen Rong,

You just have to run following simple query in postgres that will save your time to either create a custom module or writting a code.

update your_table_table set new_field=old_field;

Where, 

new_field: Field in which you want to copy data.
old_field: Field from which you want to copy data.

Avatar
Opusti
Avtor

Hi ,I find old_field is property field,it is in ir_property,and res_id is 'product.template,XX', and new_field is in product_template,how to copy it?