PG 9.0.3. How to select rows from xml
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.
Hi,
On 02/04/11 20:47, emanov wrote:
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?
Though deprecated, the xml2 contrib module with xpath_table is still
present. Installation instructions can be found on
http://www.postgresql.org/docs/9.0/static/contrib.html and the module is
documented at http://www.postgresql.org/docs/9.0/static/xml2.html.
Regards,
--
Mike Fowler
Registered Linux user: 379787