Odoo Help


Postgresql temporary table

on 10/22/16, 5:12 PM 1,174 views

Is possible manipulation on postgresql temporary table in odoo?

Presumably, the creation is not a problem, but how to organize views?

I would be grateful for any suggestion or an example.

Jaime Vasquez
On 10/23/16, 3:10 PM

In posgresql you can use temporary views and or tables but they are not accessible from Odoo.

Odoo has it's special temporary tables, they are  typically used for wizards.  To use a temporary table you can define it as a normal class, just use the following type of inheritance:  models.TransientModel (new api) or osv.osv_memory (old api).

The views are defined as normal views.





Thank you for your answer. I'm not interested in wizard with model Transient. I seek solutions with temporary table and access records per session, not per user.

on 10/24/16, 6:29 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

1 follower(s)


Asked: 10/22/16, 5:12 PM
Seen: 1174 times
Last updated: 10/23/16, 3:10 PM