Re: xml to table (as oppose to table to xml)

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
Subject: Re: xml to table (as oppose to table to xml)
Date: 2009-06-07 14:10:59
Message-ID: 200906071711.00389.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-06-07 15:34:47 Re: xml to table (as oppose to table to xml)
Previous Message Johan Nel 2009-06-07 11:18:25 Re: How to store text files in the postgresql?