Postgres Pro
Downloads
Home   >   mailing lists

Thread: Simple way to load xml into table

Simple way to load xml into table

From
Emi
Date:
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!

Re: Simple way to load xml into table

From
Rob Sargent
Date:
On 10/15/2015 11:38 AM, Emi wrote:
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!


Shame on Concordia! 8.3.  Really? (Send this up the chain)

Re: Simple way to load xml into table

From
"David G. Johnston"
Date:
On Thu, Oct 15, 2015 at 1:38 PM, Emi <emilu@encs.concordia.ca> wrote:
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!


​For "simple" I don't see anything built-it better than xpath_table(...) in the xml2 contrib module.


​This applies to any release since the standard SQL/XML stuff that we implemented in 8.3+ doesn't appear to cover this particular capability​.

David J.