Re: Decomposing xml into table

Поиск

Список

Период

Сортировка

От	Pavel Stehule
Тема	Re: Decomposing xml into table
Дата	23 июня 2020 г. 15:08:52
Msg-id	CAFj8pRAwFDnnfOwGaSUYYLf6q59qfBingeuN1t5CJMpmWoCSZg@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Decomposing xml into table (Surafel Temesgen <surafel3000@gmail.com>)
Список	pgsql-hackers

Дерево обсуждения

ú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