How can I write SQL to read an XML file into a PostgreSQL
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 data from the filesystem; the
COPY statement, among others.
But I don't see a way to write native PostgreSQL SQL statements to read the content from a filesystem entry and use that to populate an
XML value. How can I do this?