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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Färber, Franz-Josef (StMUK) <Franz-Josef(dot)Faerber(at)stmuk(dot)bayern(dot)de>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: AW: Extract text from XML, pay attention to XML Entities
Date: 2026-09-29 15:48:45
Message-ID: ed34652f-62ad-4b64-a12f-cb4640dfeeeb@aklaver.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Previous Message sutyak 2026-09-29 14:09:58 Building PostgreSQL 18 with OpenSSL in Windows with Meson