Re: Changing xml in a database - Mailing list pgsql-general

From John Gray
Subject Re: Changing xml in a database
Date
Msg-id borq2s$14ng$1@news.hub.org
Whole thread Raw
In response to Changing xml in a database  ("C G" <csgcsg39@hotmail.com>)
List pgsql-general
On Tue, 11 Nov 2003 11:02:51 +0000, C G wrote:

> Dear All,
>
> I have installed the contrib xml package and have it working, but I would
> like some advice on the best way to use it. In particular, how should I
> alter xml files? For instance, if I have:
>

There's no way at present. The support in contrib/xml is really intended
for querying document stores in which each document is updated as a whole.
There are other PG/XML solutions available which decompose XML documents
into database tables which might be better for your application, eg.
Xpsql (which I confess I've never had time to look at!):

http://gborg.postgresql.org/project/xpsql/projdisplay.php

In general, contrib/xml treats xml documents as blocks of text with XPath
queries. It was really meant as a proof of concept (which happens to work
in production :-)

Regards

John


pgsql-general by date:

Previous
From: Adam Haberlach
Date:
Subject: Re: RHEL
Next
From: DeJuan Jackson
Date:
Subject: Re: Referencing columns from system tables possible?