Simple way to load xml into table

[Emi <emilu@xxxxxxxxxxxxxxxxx>]

Hello,

For psql 8.3, is there a simple way to load xml file into table please?

E.g.,

  <rec>
    <c1>True</c1>
    <c2>test1</c2>
    <c3>e1</c3>
  </rec>
  <rec>
    <c1>false</c1>
    <c2>test2</c2>
  </rec>

Results:
t1 (c1 text, c2 text, c3 text):

c1        | c2     | c3
-----------------------------
true    | test1 | e1
false   | test2 | null
......

Thanks a lot!


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