Обсуждение: import XML
Hi all,
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 ?
PG 10 under Ubuntu 18
_________________________________
Greetings, Pascal CROZET
DBA - Qualis Consulting
_________________________________On Tue, Aug 18, 2020 at 8:27 AM PASCAL CROZET <pascal.crozet@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.
Specifically, "xmltable"
Keep in mind that "context as a document value" can just be a literal.
David J.