Re: Simple way to load xml into table

On Thu, Oct 15, 2015 at 1:38 PM, Emi <emilu(at)encs(dot)concordia(dot)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.

http://www.postgresql.org/docs/8.3/static/xml2.html

​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.