Search code examples
sqlpostgresqlbackendodoo

Track Changes in Postgresql Database

I'm working on Odoo (an ERP web application using Postgresql database).

In this software I can create a sales invoice, purchase order, accounting journal entry, etc.

When I make any transaction from the UI, I need to know what happens in the database (what tables are updated, which records are created/deleted etc.)

Solution

  • You can activate debug sql logs in odoo config by adding the line (or changing it, if exisiting) log_level=debug_sql.

    You can also change run parameters of odoo.py. Just look into the Odoo documentation which parameters are possible.