On 22.07.20 01:49, PASCAL CROZET wrote:
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
*_________________________________*
Cordialement, *Pascal CROZET**
*
*DBA *- Qualis Consulting
•300 Route Nationale 6 – 69760 LIMONEST
*_________________________________*
Pascal, your situation is unclear - at least for me. Please give us more
information concerning
* your pg_get_file function
* a short excerpt of your file
* the DDL of your table
* what is your understanding of a 'cell'?
Is this helpful:
https://www.postgresql.org/docs/current/functions-xml.html ?
Kind regards, Jürgen Purtz
