how to update xml datatype column in postgresql

Question

PostgreSQL Version 9.1,

i have a table,

xmltest=# \d xmltest
    Table "public.xmltest"
 Column  |  Type   | Modifiers 
---------+---------+-----------
 id      | integer | not null
 xmldata | xml     | 
Indexes:
    "xmltest_pkey" PRIMARY KEY, btree (id)

xmltest=# select * from xmltest;
 id |                xmldata                
----+---------------------------------------
  1 | <root>                               +
    | <child1>somedata for child1 </child1>+
    | <child2>somedata for child2 </child2>+
    | </root> 
(1 row)

now how to update the value inside the element/tag child2,

i don't prefer to update the whole column at once,

is their a way to do update/add/delete that particular value of tag, if so please share :)

Community · Accepted Answer · 2017-05-23 11:55:48Z

3

PostgreSQL XML functions are aimed a producing and processing XML, not so much at manipulating it, I am afraid.

You can extract values with xpath(), there are a number of functions to build XML, but I would not know of built-in functionality to update elements inside a given XML value.

edited May 23, 2017 at 11:55

CommunityBot

11 silver badge

answered Jun 8, 2012 at 21:36

Erwin Brandstetter

668k159 gold badges1.2k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to update xml datatype column in postgresql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related