Обсуждение: Simple way to load xml into table
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!
On 10/15/2015 11:38 AM, Emi wrote:
Hello,Shame on Concordia! 8.3. Really? (Send this up the chain)
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!
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.