Tagged Questions
2
votes
1answer
313 views
How can I escape XML field in XML-output query?
I have following request:
SELECT XMLAGG(data) FROM
(SELECT XMLELEMENT(name item, XMLFOREST(
title,
body as description,
date_created as date,
'http://example.com/news'||id as link
)) AS ...
3
votes
3answers
3k views
SQL to read XML from file into PostgreSQL database
How can I write SQL to read an XML file into a PostgreSQL XML value?
PostgreSQL has a native XML data type with the XMLPARSE function to parse a text string to that type. It also has ways to read ...
