Hello Everyone,
Is there any way we can check out the list some important tables of odoo in postgres database. i am looking for sales, purchase, inventory related tables.
Regards
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
3
Replies
10428
Views
Hi,
Based on the comment you have added, it seems you need to know which table hold, what sort of information's.
Lets take a case of sale order, if you need to know the which table in the PostgreSQL hold this records, you can open the sale order form view and in the url you can see an attribute model, this model represent the db table.
If you see in the url as sale.order, then its related postgreSQL table is sale_order .
Also if you open the debug mode(odoo developer mode), by clicking view meta data also you can get the model details.
Once you get the model details, using terminal or using tools like pgadmin, you can connect to database and perform the sql operations.
Thanks
The first and easiest is to enable debug mode, go to Settings->Technical->Models under database structure group->your_desired_model . It will show you exact same structure in postgres databases.
Or refer to Cybrosys Techno Solutions answer above.
Hope this will help you.
Hi,
You can get the list of tables in postgres database using two solutions either through pgadmin or through terminal
Check this link
https://phoenixnap.com/kb/how-to-connect-postgresql-database-command-line
https://linuxize.com/post/how-to-list-databases-tables-in-postgreqsl/
Regards
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
2
Nov 24
|
1845 | ||
|
2
Oct 24
|
330 | ||
|
2
Aug 24
|
358 | ||
|
3
Jul 24
|
6438 | ||
|
0
Apr 24
|
360 |
Dear team,
Pleasant Day!
I appreciate your response, could you please let me know what are the tables which holds inventory, sales, purchase and finance related information, of course we can achieve this by using the terminal or pgadmin but does not know the exact purpose of tables, view and procedures etc..
Dear Niaz Raphy / Walid,
Thanks for your comments, yes this is what the easiest way to find the tables i have identified the tables by using the information provided.
1) Sales Order
sale.order = sale_order
Delivery Note
stock.picking = stock_picking
Invoice Details
account.move = account_move
Purchase Order
purchase.order = purchase_order
Receipt
stock.picking = stock_picking
Vendor Bill
account.move = account_move
Hope this solves my problem
Regards