On Tue, Aug 18, 2020 at 8:27 AM PASCAL CROZET < pascal.cro...@qualis-consulting.com> wrote:
> I want to import XML file into PG database table. > I've find functions to get the XML content of a cell after imported an XML > file with the pg_get_file function. > But, I want to explode the XML content to colums. How can I do this ? > In short, you need to import the content as a document value first then use functions to explode that document. You should find the documentation helpful. https://www.postgresql.org/docs/10/functions-xml.html Specifically, "xmltable" Keep in mind that "context as a document value" can just be a literal. David J.