Thread: Re: xml support

Re: xml support

From
"John Gray"
Date:
In article <9sonop$f8k$1@news.tht.net>, "pipo" <pipo@idecnet.com> wrote:

> hi all,
>     recently i have see a discussion about support xml in postgres....
>     and
> someone suggest that it can be done using xerces-c api.
>     Does anyone try to add xml as data type to postgres using xerces?
>     what
> problems did you found? Is it very complicated?
>

I have done a little work on XML support in Postgres. Postgres (from version
7.1) supports long attribute values, so you can store an entire XML
document in a single column, rather than have to parse it.  I don't see a
real need to add XML as a separate data type becuase I think the text
type should support it well enough.

The routines I contributed use either expat or libxml2 to provide parsing
functions -the libxml2 version also provides proper XPath support so that
you can perform XPath queries on XML documents within the DB. You will
find the code in contrib/xml within the PostgreSQL distribution. The code
is really only intended as an example of how you can easily add such
functions to Postgres -it isn't a full XML DB system!

Regards

John

--
John Gray
Azuli IT    http://www.azuli.co.uk      +44 121 693 3397
jgray@azuli.co.uk