Request a Demo
Home   >   mailing lists

AW: Extract text from XML, pay attention to XML Entities - Mailing list pgsql-general

From Färber, Franz-Josef (StMUK)
Subject AW: Extract text from XML, pay attention to XML Entities
Date
Msg-id ed1a375c6fe6475892ac1e222cb463bd@stmuk.bayern.de
Whole thread
In response to Extract text from XML, pay attention to XML Entities  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: AW: Extract text from XML, pay attention to XML Entities
List pgsql-general
Tree view

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> 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.

 

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: PostgreSQL license inquiry: source code disclosure obligations for commercial redistribution
Next
From: sutyak
Date:
Subject: Building PostgreSQL 18 with OpenSSL in Windows with Meson