Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL and XML support - Mailing list pgsql-general

From Doug Bloebaum
Subject Re: PostgreSQL and XML support
Date
Msg-id caa2de8a0509061214314baf12@mail.gmail.com
Whole thread Raw
In response to PostgreSQL and XML support  ("Andrey Fomichev" <fomichev@ispras.ru>)
Responses Re: PostgreSQL and XML support
List pgsql-general
Tree view
On 9/6/05, Andrey Fomichev <fomichev@ispras.ru> wrote:
- Are there any of you who need to store and query XML data?
- Do you already use PostgreSQL to store XML data or you are
  just thinking about it?

The project I'm currently working on uses XML for both data extraction from Postgres and as a means to transmit data to Postgres for storage.

- If you store XML data in PostgreSQL, how do you do it? What tool
  do you use?

We're using Oracle's XSQL servlet (http://download-west.oracle.com/docs/cd/B14117_01/appdev.101/b10794/adx09xsq.htm) with Apache tomcat (http://jakarta.apache.org/tomcat/) as its servlet container.  The only change we've made to  XSQL is the addition of a custom tag (<xsql:pg-func>) in order to make use of Postgres functions returning REF CURSOR.  Aside from that, we're using XSQL out-of-the-box.

Granted, we're not really manipulating XML within the database, rather we're using XML as a sort of database-neutral interface.

- Do you need some advanced query capabilities? Like XQuery, XPath 2.0

No.

- Do you need some advanced update capabilities? Like node-level updates

No.


pgsql-general by date:

Previous
From: Keary Suska
Date:
Subject: Re: Bug or ?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Debug plpgSQL stored procedures