Odoo Help


This community 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.


List table columns on PostgreSQL via command line

Yassine TEIMI
on 11/17/14, 9:43 AM 1,156 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?

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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)


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