====== PostgreSQL ======


Restore with psql

<code bash>
psql -U admin -W -h localhost -d odoo_main -f dump.sql
</code>
desde un dump
<code bash>
pg_restore -v -Fc -w -O -x -h 127.0.0.1 -U admin -d basededatos archivo.dump
</code>

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

Update with join
<code sql>
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'
</code>