PostgreSQL 101 tutorial

Question

I'm new to Odoo and would like to have access to the database.
I tried installing PostgreSQL w/o much luck.
I just need to run basic SQL commands to better understand the database.
Inquiry only.
Any suggestions, perhaps simpler tool?

Ray Carnes (ray) · Answer

It is better to use the Database Structure Menu
In Developer Model, navigate to* Settings --> Technical *
Up to 35% of the Fields in Odoo are not stored in PostgreSQL
See also:
https://www.odoo.com/forum/help-1/visual-database-design-schema-for-odoo-168392 [1]
https://www.odoo.com/documentation/master/developer/tutorials/server_framework_101/03_basicmodel.html [2]

[1] https://www.odoo.com/forum/help-1/visual-database-design-schema-for-odoo-168392
[2] https://www.odoo.com/documentation/master/d

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,

Refer to the following.

* https://www.cybrosys.com/blog/an-introduction-to-postgresql-queries [1]
* https://www.cybrosys.com/research-and-development/postgres/how-to-set-up-bidirectional-replication-in-postgresql [2]
* https://www.cybrosys.com/blog/initialization-and-basic-settings-of-postgresql [3]
* https://www.cybrosys.com/blog/how-to-optimize-an-odoo-server-postgresql [4]

Hope it helps

[1] https://www.cybrosys.com/blog/an-introduction-to-postgresql-queries
[2] https://www.cybrosys.c

Gerelateerde posts	Antwoorden	Weergaven
[Atención al Cliente \| México] ¿Cómo me comunico con un operador de Royal Caribbean? development	0 jun. 26	1
Feature Request: Native Integration with Label Printing Scales in Odoo POS development	0 mei 26	2
Odoo 19 POS Receipt Customization – Hide Default Unit Price & Display Custom MRP Line development	0 mei 26	28
+51 17052238[Latam∞Ayuda∞Perú∞Oficial] ¿Cómo hablo con una persona de Latam? development	0 mei 26	9
Looking for Odoo 19 Survey File Upload / Attachment module or customization guide development	0 mei 26	1

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!