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>
