Odoo Help


Please Help Me In PostgreSQL ?

Ali Abdelmonem Mustafa Amer
on 11/6/13, 5:04 AM 1,056 views

Hi All

I'm New In OpenErp Developing So I Have Many Questions That I Want To Know It's Answers

1- What The Names Of PostgreSQL Data Base Refers To like (Res_Partner Table , ir_Model Table ) (Res And Ir , ..... Etc ) Refers To ?


Jakub Krzempek
On 11/6/13, 5:23 AM

When you are logged into your OERP, go to upper-right corner, click your username and choose About OpenERP. There you have a button to activate developer mode - click it. Thanks to it when you hover over a field you will be given with it's model, relations, type etc. That way you will find out ORM version of a database table. Now in a PostgreSQL console type \d to list all of your tables or e.g. \d res_partner if you want to show res.partner. A general rule is to substitute . with _ I don;t know if it answers your question, though. It was kind of a blurry one.


Thanks A Lot About Your Answer But I Have One More Question

Ali Abdelmonem Mustafa Amer
on 11/6/13, 5:50 AM

Thanks A Lot For Your Answer But I Have question (res,ir ......) The First digit Of The PostgreSQL Tables Have Two Or More Character Like (res_Partner) I Think There Is Reason For Called It With This Expression So If you Know The Reason I Will Be Glade For You Jakub

Ali Abdelmonem Mustafa Amer
on 11/6/13, 5:54 AM

I can only assume this is to easily distinguish to which module a table belongs. Probably its also for convenience - you have all ir_ or res_ tables grouped together.

Jakub Krzempek
on 11/6/13, 9:37 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 11/6/13, 5:04 AM
Seen: 1056 times
Last updated: 3/16/15, 8:10 AM