Thread: 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