This question has been flagged
1 Reply
2624 Views

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
Discard
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
Discard
Author

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?