Simple way to load xml into table - Mailing list pgsql-general

From Emi
Subject Simple way to load xml into table
Date
Msg-id 561FE488.4090704@encs.concordia.ca
Whole thread Raw
Responses Re: Simple way to load xml into table  (Rob Sargent <robjsargent@gmail.com>)
Re: Simple way to load xml into table  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
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!


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pgpool ssl handshake failure
Next
From: Rob Sargent
Date:
Subject: Re: Simple way to load xml into table