Re: XML and PostgreSQL

What do you plan to do with the XML, and how do you envision the database as a
part of that plan?

It seems like anything you'd like to do with XML in postgres you could do with
some custom types, and some stored procedures. I think that could be helpful
because you could, for example, query based on an XML element within an
attribute of a relation.

You could even share the functions, if you were so inclined.

One thing to keep in mind is that an XML document could be structured very
differently from another XML document. If you did want to store XML documents
in postgres, and you wanted to query and manipulate them inside the database,
they'd need to have a definate structure for documents within an attribute.

You can also, of course, just store the XML document in a text field and let
your app handle it.

Regards,
    Jeff



On Wednesday 11 September 2002 01:33 pm, Dan Ostrowski wrote:
> I am wondering if any of you work with XML-PostgreSQL extensively.
>
> I usually do presentations in HTML for web stuff, but I am now about to
> embark on a large ( for me ) project with potentially many layers of
> presentation and data manipulation.
>
> I am wondering how well PostgreSQL deals with XML and whether, in your
> optinions, it is worth trying to learn a decent amount of XML to
> accomodate this project. It's going to be quite long anyhow, since i am
> doing it pretty much pro-bono and by myself, so a little research time
> might be alright if the advantages are great enough.
>
> thoughts?
>
> regards,
> dan
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html