Hello David, Thanks for your reply.
It’s just strange and unfortunate that a) Postgres does not offer a simple solution b) Postgres had indeed offered a simple solution, xml_string, in the xml2 extension, which is deprecated (and won't deal with namespaces). Regards, Franz-Josef Färber Von: David G. Johnston <[email protected]> Gesendet: Montag, 28. September 2026 09:27 An: Färber, Franz-Josef (StMUK) <[email protected]> Cc: [email protected] Betreff: Extract text from XML, pay attention to XML Entities On Monday, September 28, 2026, Färber, Franz-Josef (StMUK) <[email protected]<mailto:[email protected]>> wrote: *ping* anybody interested to reply? Thank You. I suspect you’ve framed this up fully and correctly and are left with choosing whichever of your last resorts you deem least offensive. I’d probably go with a custom text transformer personally; though why you need to do this, the risks involved, tend to matter for such decisions. David J.
