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: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers

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 and the module is 
documented at


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-2018 The PostgreSQL Global Development Group