Skip to content

Instantly share code, notes, and snippets.

@kerbrose

kerbrose/odoo_dev.sql

Last active March 3, 2024 12:21
Show Gist options
  • Save kerbrose/a3655d6307e00bbc5ad62131031d1e49 to your computer and use it in GitHub Desktop.
Save kerbrose/a3655d6307e00bbc5ad62131031d1e49 to your computer and use it in GitHub Desktop.
Download ZIP
useful psql commands
Raw
odoo_dev.sql
# used to delete a view that contains a removed field
delete from ir_ui_view where position('FIELD_NAME' in arch_db)>0;
# in odoo 16 ir_ui_view becomes a jsonb
delete from ir_ui_view where arch_db->>'en_US' ilike '%FIELD_NAME%' ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment