Re: AW: Extract text from XML, pay attention to XML Entities

On 9/29/26 6:12 AM, Färber, Franz-Josef (StMUK) wrote:
> Hello David,
>
> Thanks for your reply.
>
> It’s just strange and unfortunate that
>
> a) Postgres does not offer a simple solution

I think you are left with from here:

https://www.postgresql.org/docs/current/xml2.html

"If you find that some of the functionality of this module is not
available in an adequate form with the newer API, please explain your
issue to <pgsql-hackers(at)lists(dot)postgresql(dot)org> so that the deficiency can
be addressed."

>
> 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
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com