UPDATE XML DATA USING SQL QUERY ON POSTGRESQL



I have XML data to update, and I have only the sql query to do that. How this can be done ?


I used UPDATE TABLE SET ARCH='XML DATA' where name='xxx'; but when pasting the XML code on the shell, it kind of compiles, knowing that the code has some special characters of cours like the ' character.


I am on Ubuntu server shell.


No comments:

Post a Comment