Odoo Help


List table columns on PostgreSQL via command line

Yassine TEIMI
on 11/17/14, 9:43 AM 2,014 views

I'm on ubuntu server 12.04 LTS,

Q1. I need to acces to the ir_ui_view table, and modify a column.

S1. For that I need to know the columns architecture, and perform a SQL query (UPDATE)

I am now connected to my database, I can List all tables on my database and view their names.

Could you tell me how to repond to Q1.

Is S1 a valid action ?.



you can view ir_ui_view table by this query:- " select * from ir_ui_view; " do you have any idea about normal query to do your required action?

Baiju KS
on 11/17/14, 10:56 AM

The name of the column that I want to update is : arch. wich is the view XML architecture. I want to do an update of this column, by deleting some xml content. update ir_ui_view set arch='new xml content' where name='res.users.form'

Yassine TEIMI
on 11/17/14, 11:15 AM

Or can I just access the xml content, and modify it, with a psql manipulation, without sql query ?

Yassine TEIMI
on 11/17/14, 11:18 AM
Mohamed Essakali
On 12/9/14, 9:39 AM

You can do that using menu Settings->Technical->Actions->Window Actions

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

2 follower(s)


Asked: 11/17/14, 9:43 AM
Seen: 2014 times
Last updated: 3/16/15, 8:10 AM