I need to do an update to a view in the  field "arch", but when an error occurs I try me by my content has single and double quotes, so postgres does not know where it begins and where it ends.

For example thats what I want to update:

--base_company_prefix.xml

update ir_ui_view set arc='<?xml version="1.0"?>

<data>

<field name="name" position="before" >

<field name="prefix" nolabel="1" class="oe_inline"/> -

</field>

</data>' where id=1067; 

This is a mistake, but not how to do the update of the arch field.

Could anyone help me please?.