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
|
Список | 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 по дате отправления: