Postgres Pro
Downloads
Home   >   mailing lists

Re: Decomposing xml into table - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Decomposing xml into table
Date
Msg-id CAFj8pRAwFDnnfOwGaSUYYLf6q59qfBingeuN1t5CJMpmWoCSZg@mail.gmail.com
Whole thread Raw
In response to Re: Decomposing xml into table  (Surafel Temesgen <surafel3000@gmail.com>)
List pgsql-hackers
Tree view


út 23. 6. 2020 v 13:59 odesílatel Surafel Temesgen <surafel3000@gmail.com> napsal:
hey Pavel

On Mon, Jun 22, 2020 at 9:59 PM Pavel Stehule <pavel.stehule@gmail.com> wrote:

Did you try the xmltable function?


yes i know it  but i am proposing changing given xml data in to relational form and insert it to desired table at once

It is a question of how common it is.  Because there is no common format for xml, I agree with Tom, so it should not be part of core. A import from XML can be done with COPY PROGRAM

or some special tools like https://github.com/okbob/pgimportdoc

There is too high variability so some special external tool will be better (more cleaner, more user friendly).

Regards

Pavel



regards
Surafel

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [PATCH] Initial progress reporting for COPY command
Next
From: Josef Šimánek
Date:
Subject: Re: [PATCH] Initial progress reporting for COPY command