The data cleaning module should be careful when cleaning official standard module data, but when cleaning modules written by oneself, many data cannot be cleaned smoothly. Directly enter the Odoo cloud server and go to PostgreSQL for cleaning.
Before manually cleaning odoo data, first confirm that the data can be cleaned. It is recommended to first use the data cleaning module on apps to clean the remaining residual data, and then proceed with manual cleaning.
The data cleaning preparation work is as follows:
1. Log in to the odoo server via a link or open the terminal in the current season to execute commands;
2. Connect to pg database: #sudo su - postgres Switch to the postgres user;
3、在 postgres 用戶下執行：#psql -d <資料庫名稱> 即可連結到指定資料庫上；
4. After connecting to the PostgreSQL database, execute the SQL statement command: Delete from <database table name>
