postgresqlHow can I get a value from a PostgreSQL XML column?

You can get a value from a PostgreSQL XML column using the xpath() function.

Example code

SELECT xpath('/foo/bar/text()', xml_column)
FROM some_table;

Output example

┌───────────────────────┐
│    xpath              │
├───────────────────────┤
│ {SomeValue}           │
└───────────────────────┘

The code above uses the xpath() function to get the value of the bar node inside the foo node of the xml_column column.

Code explanation

• xpath() - a PostgreSQL function used to get a value from an XML column
• /foo/bar/text() - an XPath expression used to specify the target node
• xml_column - the XML column from which the value is retrieved

Helpful links

• PostgreSQL Documentation - XPath Functions

Edit this code on GitHub