Simple way to load xml into table

From: Emi <emilu(at)encs(dot)concordia(dot)ca>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Simple way to load xml into table
Date: 2015-10-15 17:38:16
Message-ID: 561FE488.4090704@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2015-10-15 17:45:53 Re: Simple way to load xml into table
Previous Message Adrian Klaver 2015-10-15 16:37:24 Re: pgpool ssl handshake failure