Skip site navigation (1) Skip section navigation (2)

PG 9.0.3. How to select rows from xml

From: emanov <emanovs(at)yandex(dot)ru>
To: pgsql-hackers(at)postgresql(dot)org
Subject: PG 9.0.3. How to select rows from xml
Date: 2011-04-02 19:47:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Hi all!
What i need is transform xml document to table like that:
insert into tmp("Name", "Value")
select t.Name, t.Value from myxml.Nodes("/doc/person") as
or similar. In fact I have many rows with many columns.

How I can do it with PG 9.0.3 where I can't find xpath_table?

View this message in context:
Sent from the PostgreSQL - hackers mailing list archive at


pgsql-hackers by date

Next:From: Dimitri FontaineDate: 2011-04-02 20:10:18
Subject: Re: Another swing at JSON
Previous:From: Tom LaneDate: 2011-04-02 19:40:23
Subject: Re: Process local hint bit cache

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group