Odoo Help


JSON field for Postgresql 9.2 JSON type?

on 9/17/13, 1:34 PM 1,689 views

It would be really useful to be able to use the new JSON type available in Postgresql 9.2+. Question is, which OpenERP field type would work with this? Can an OpenERP text field be used for this type?

Michael Mugge
On 3/29/17, 10:02 AM

It really depends on how you want to use the field. If the data in the field won't be used very often then you might want to just use a text field and create a materialized view based on the data in the column that has your JSON, but converted to a Postgres JSON field. This will allow you to index by JSON nodes and get more out of Postgres' JSON support.

If you don't need all the JSON support features from Postgres then ignore everything above and just use a Text field.

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: 9/17/13, 1:34 PM
Seen: 1689 times
Last updated: 3/29/17, 10:02 AM