From: Färber, Franz-Josef (StMUK) <Franz-Josef.Faerber@stmuk.bayern.de>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: AW: Extract text from XML, pay attention to XML Entities
Date: Tue, 29 Sep 2026 13:12:49 +0000
Message-ID: <ed1a375c6fe6475892ac1e222cb463bd@stmuk.bayern.de> (raw)
In-Reply-To: <CAKFQuwYa3reOXUAtf_CqBbC5P1FOwyzrkFK0uxochhcpGXrx-A@mail.gmail.com>
References: <615fa488caa2422393498300d476dcc0@stmuk.bayern.de>
<4ba2604dc46b4f58ad500febc7f6e895@stmuk.bayern.de>
<CAKFQuwYa3reOXUAtf_CqBbC5P1FOwyzrkFK0uxochhcpGXrx-A@mail.gmail.com>
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 <david.g.johnston@gmail.com>
Gesendet: Montag, 28. September 2026 09:27
An: Färber, Franz-Josef (StMUK) <Franz-Josef.Faerber@stmuk.bayern.de>
Cc: pgsql-general@lists.postgresql.org
Betreff: Extract text from XML, pay attention to XML Entities
On Monday, September 28, 2026, Färber, Franz-Josef (StMUK) <Franz-Josef.Faerber@stmuk.bayern.de<mailto:Franz-Josef.Faerber@stmuk.bayern.de>> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: Franz-Josef.Faerber@stmuk.bayern.de, david.g.johnston@gmail.com, pgsql-general@lists.postgresql.org
Subject: Re: AW: Extract text from XML, pay attention to XML Entities
In-Reply-To: <ed1a375c6fe6475892ac1e222cb463bd@stmuk.bayern.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox