[GENERAL] xml to table (as oppose to table to xml)

[Grzegorz Jaśkiewicz]

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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general