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'
ivan