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

Re: PG 9.0.3. How to select rows from xml

From: Mike Fowler <mike(at)mlfowler(dot)com>
To: emanov <emanovs(at)yandex(dot)ru>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PG 9.0.3. How to select rows from xml
Date: 2011-04-04 07:51:01
Message-ID: 4D997865.7080603@mlfowler.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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


In response to

pgsql-hackers by date

Next:From: Susanne EbrechtDate: 2011-04-04 08:06:04
Subject: Re: [HACKERS] found a very confusing and maybe outdated sentence
Previous:From: Joseph AdamsDate: 2011-04-04 05:46:17
Subject: Re: cast from integer to money

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