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 co
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 direc
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 r
ú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 at
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 for
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 need
