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

is there any way currently to convert xml file in format like below,
to a table ?


<foo>
  <section>
    <ssc id="foo1">
       <foo_data a="1" b="2"/>
       <foo_more_data c="a" d="b"/>
    </ssc>
  </section>

  <section>
    <ssc id="foo2">
        ...
    </ssc>
  </section>

  <section>
...
  </section>

  <section>
...
  </section>
</foo>



--
GJ