Re: PostgreSQL and XML support

Поиск
Список
Период
Сортировка
От Doug Bloebaum
Тема Re: PostgreSQL and XML support
Дата
Msg-id caa2de8a0509061214314baf12@mail.gmail.com
обсуждение исходный текст
Ответ на PostgreSQL and XML support  ("Andrey Fomichev" <fomichev@ispras.ru>)
Ответы Re: PostgreSQL and XML support  (Oleg Bartunov <oleg@sai.msu.su>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Keary Suska
Дата:
Сообщение: Re: Bug or ?
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Debug plpgSQL stored procedures