By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,692 Members | 1,998 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,692 IT Pros & Developers. It's quick & easy.

Changing xml in a database

P: n/a
C G
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:

<name>None</name>

and I wanted to update 'None' to 'John', what's the best way of doing this?
Can xml contrib package do this for me, if so how? What including a new
level, e.g.

<name>None</name>
<address>somewhere</address>

Many thanks

Colin

__________________________________________________ _______________
Find a cheaper internet access deal - choose one to suit you.
http://www.msn.co.uk/internetaccess
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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/...rojdisplay.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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.