pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
AW: Extract text from XML, pay attention to XML Entities
2+ messages / 2 participants
[nested] [flat]

* AW: Extract text from XML, pay attention to XML Entities
@ 2026-09-29 13:12  Färber, Franz-Josef (StMUK) <Franz-Josef.Faerber@stmuk.bayern.de>
  0 siblings, 1 reply; 2+ messages in thread

From: Färber, Franz-Josef (StMUK) @ 2026-09-29 13:12 UTC (permalink / raw)
  To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>

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.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: AW: Extract text from XML, pay attention to XML Entities
@ 2026-09-29 15:48  Adrian Klaver <adrian.klaver@aklaver.com>
  parent: Färber, Franz-Josef (StMUK) <Franz-Josef.Faerber@stmuk.bayern.de>
  0 siblings, 0 replies; 2+ messages in thread

From: Adrian Klaver @ 2026-09-29 15:48 UTC (permalink / raw)
  To: Färber, Franz-Josef (StMUK) <Franz-Josef.Faerber@stmuk.bayern.de>; David G. Johnston <david.g.johnston@gmail.com>; +Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>

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@lists.postgresql.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.klaver@aklaver.com






^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2026-09-29 15:48 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-09-29 13:12 AW: Extract text from XML, pay attention to XML Entities Färber, Franz-Josef (StMUK) <Franz-Josef.Faerber@stmuk.bayern.de>
2026-09-29 15:48 ` Adrian Klaver <adrian.klaver@aklaver.com>

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