Decomposing xml into table

From: Surafel Temesgen <surafel3000(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Decomposing xml into table
Date: 2020-06-22 18:49:33
Message-ID: CALAY4q91_3VES3ztKgHp84L6=6-pMtEnuKacUErauehWVnnAFA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Comments?

regards

Surafel

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2020-06-22 18:59:00 Re: Decomposing xml into table
Previous Message Justin Pryzby 2020-06-22 18:40:48 Re: Warn when parallel restoring a custom dump without data offsets