Re: Decomposing xml into table

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Decomposing xml into table
Дата
Msg-id CAFj8pRDUa5p68SYeEuHDxCGaa7Pm7gzfapNzO5iYo8aDZhVBfQ@mail.gmail.com
обсуждение исходный текст
Ответ на Decomposing xml into table  (Surafel Temesgen <surafel3000@gmail.com>)
Ответы Re: Decomposing xml into table  (Surafel Temesgen <surafel3000@gmail.com>)
Список pgsql-hackers


po 22. 6. 2020 v 20:49 odesílatel Surafel Temesgen <surafel3000@gmail.com> napsal:
In PostgreSQL there are a function table_to_xml to map the table content to xml value but there are no functionality to decompose xml back into table which can be used in system that uses xml for transport only or there are a need to migrate to database system to use database functionality. I propose to have this by extending copy to handle xml format as well because file parsing and tuple formation functions is in there and it also seems to me that implement it without using xml library is simpler

Did you try the xmltable function?


Regards

Pavel

Comments?

regards

Surafel

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Surafel Temesgen
Дата:
Сообщение: Decomposing xml into table
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: tag typos in "catalog.sgml"