How to perform execute SQL query in Odoo | Database Queries | SQL Statements | PSQL queries

Hello, I have created a column in the table using sql raw query, The column is now present in the table but odoo orm is not recognizing that column, How can I resolve that?

Chukran 🎉

Hello friend, are we able to make alter table - Add column / remove column operation with self.env.cr.execute ?

i want to insert values like that:



self.env.cr.execute("insert into scms_equ_count(equipment_catagory,tcount) values(select equipment_catagory,count(*) from scms_company_equipment group by equipment_catagory)")

please help me how i can assign data to variables.

@Weblearns my queary is running fine. now i want assign data to variables.

why will it bypass odoo security ? isnt this an issue ?

How to do it in windows 10? currently, I can only access database by using postgre shell, but it still hard through pycharm's terminal like yours..:'(

Python console error's "self not defined", "env not define" etc.

thanks for the tips, very handy