Re: Decomposing xml into table

út 23. 6. 2020 v 13:59 odesílatel Surafel Temesgen <surafel3000(at)gmail(dot)com>
napsal:

> hey Pavel
>
> On Mon, Jun 22, 2020 at 9:59 PM Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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
>