PostgreSQL

Restore with psql

psql -U admin -W -h localhost -d odoo_main -f dump.sql

desde un dump

pg_restore -v -Fc -w -O -x -h 127.0.0.1 -U admin -d basededatos archivo.dump

Options

• (-v) Verbose
• (-Fc) Custom Format
• (-O) no owner
• (-x) no ACL
• (-w) disable password prompt

Update with join

UPDATE account_move_line SET balance_second_currency = debit_second_currency - credit_second_currency FROM  account_move AS am WHERE move_id = am.id AND am.name = 'MANUAL/2022/10/0002'