Is it possible to truncate the sale.order table from ubuntu terminal.
If yes please mention how it .
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Boekhouding
- Voorraad
- PoS
- Project
- MRP
Deze vraag is gerapporteerd
1
Beantwoorden
9596
Weergaven
On the terminal
step 1. Locate postgresql, e.g. cd /opt/PostgreSQL/9.1/bin
step 2. ./psql --u database name.
step 3. /l (database list)
step 4. /d (table list)
To truncate table:-
truncate table table_name cascade (cascade if table contain relationship)
Thank Gopakumar. Is there any way to remove all the datas(sales, hr, products) in the database in a single step. But not affecting the default values. eg. In product's table product service
Error occured like this... root@jyothish-System-Product-Name:/usr/lib/postgresql/9.1/bin# ./psql --u ILAJ admin psql: FATAL: Peer authentication failed for user "ILAJ"
@47114 check the username and password you have entered, make sure that you are using correct username and password.
i use the command TRUNCATE TABLE sale_order RESTART IDENTITY CASCADE; The table will be truncated but the id will not be reset . How can be make the id to start from the begining..
Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!
Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!
Aanmelden