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 w
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_ta
