Extract xpath in postgres

Question

have a postgres query to extract xml , not able to provide the xpath correctly

select column1, xmlcolumn from tabla

xmlcolumn is of the type:

<tag1>
  <tag2>
    <tag3>test</tag3>
  </tag2>
</tag1>

I need to extract value of tag3

Any idea how this can be done ?

S-Man · Accepted Answer · 2018-10-04 14:11:53Z

2

SELECT xpath('/tag1/tag2/tag3/text()', xmlcolumn)

answered Oct 4, 2018 at 14:11

S-Man

24k9 gold badges51 silver badges78 bronze badges

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

1 Answer 1