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
> 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.
Registered Linux user: 379787
In response to
pgsql-hackers by date
|Next:||From: Susanne Ebrecht||Date: 2011-04-04 08:06:04|
|Subject: Re: [HACKERS] found a very confusing and maybe outdated sentence|
|Previous:||From: Joseph Adams||Date: 2011-04-04 05:46:17|
|Subject: Re: cast from integer to money|