On 06/23/20 08:57, Thomas Kellerer wrote:
> Surafel Temesgen schrieb am 23.06.2020 um 13:59:
>>> 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
> Well, xmltable() does change the XML
On 6/22/20 8:49 PM, Surafel Temesgen wrote:
Comments?
I feel it would make more sense to add features like this to an external
tool, e.g pgloader. But even if we add it to the core PostgreSQL project
I feel the XML parsing should be done in the client, not in the database
server. The COPY
Surafel Temesgen schrieb am 23.06.2020 um 13:59:
>> 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
Well, xmltable() does change the XML data to a relational form and
the result can
Hey Tom
On Mon, Jun 22, 2020 at 10:13 PM Tom Lane wrote:
> Big -1 on that. COPY is not for general-purpose data transformation.
> The more unrelated features we load onto it, the slower it will get,
> and probably also the more buggy and unmaintainable.
what new format handling takes to add
út 23. 6. 2020 v 13:59 odesílatel Surafel Temesgen
napsal:
> hey Pavel
>
> On Mon, Jun 22, 2020 at 9:59 PM Pavel Stehule
> 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
hey Pavel
On Mon, Jun 22, 2020 at 9:59 PM Pavel Stehule
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
regards
Surafel
Surafel Temesgen writes:
> 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
Huh? XMLTABLE does that, and it's even SQL-standard.
> I propose to have this by extending copy to handle xml
po 22. 6. 2020 v 20:49 odesílatel Surafel Temesgen
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
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