PG 9.0.3. How to select rows from xml - Mailing list pgsql-hackers

From emanov
Subject PG 9.0.3. How to select rows from xml
Date
Msg-id 1301773632062-4278076.post@n5.nabble.com
Whole thread Raw
Responses Re: PG 9.0.3. How to select rows from xml  (Mike Fowler <mike@mlfowler.com>)
List 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
t('Name:varchar|Value:int')
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:
http://postgresql.1045698.n5.nabble.com/PG-9-0-3-How-to-select-rows-from-xml-tp4278076p4278076.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: FDW state from plan time
Next
From: Robert Haas
Date:
Subject: Re: GUC assign hooks (was Re: wal_buffers = -1 and SIGHUP)