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?
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'
Or can I just access the xml content, and modify it, with a psql manipulation, without sql query ?