import XML

From: PASCAL CROZET <pascal(dot)crozet(at)qualis-consulting(dot)com>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: import XML
Date: 2020-08-18 15:27:46
Message-ID: 66594af2af3f49f49724321d684eef93@qualis-consulting.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
_________________________________

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2020-08-18 15:38:39 Re: import XML
Previous Message Srinivasa T N 2020-08-18 15:00:39 Re: Database logins taking longer and longer, showing up as "authentication" in ps(1)