Re: xml to table (as oppose to table to xml) - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: xml to table (as oppose to table to xml)
Date
Msg-id 200906071711.00389.peter_e@gmx.net
Whole thread Raw
In response to xml to table (as oppose to table to xml)  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Responses Re: xml to table (as oppose to table to xml)
List pgsql-general
On Monday 01 June 2009 12:53:08 Grzegorz Jaśkiewicz wrote:
> is there any way currently to convert xml file in format like below,
> to a table ?

I have some code that does this, but it was written a long time ago and will
probably need some polishing.

One main problem is how you specify that exact mapping mechanism.  AFAIR, my
code accepted as input the exact format that table_to_xml etc. put out (and
probably crashes otherwise).  In reality you probably want an XSLT
transformation in between.  Which would require a smoother XSLT integration
into the backend code.

I think this is something we could work on for 8.5.


pgsql-general by date:

Previous
From: Florian Weimer
Date:
Subject: Re: How to store text files in the postgresql?
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: xml to table (as oppose to table to xml)