Re: Current state of XML capabilities in PostgreSQL? - Mailing list pgsql-general

From Scott Bailey
Subject Re: Current state of XML capabilities in PostgreSQL?
Date
Msg-id 4AB16335.2000807@comcast.net
Whole thread Raw
In response to Current state of XML capabilities in PostgreSQL?  (Nathan Widmyer <lighthousej@gmail.com>)
Responses Re: Current state of XML capabilities in PostgreSQL?
List pgsql-general
> I'm looking for the current state of XML capabilities in PostgreSQL and
> I'm coming up with a lot of confusing links and a bit short on
> documentation.


Postgres' XML is still lacking in a few spots. But the core
functionality is certainly there to do all of the every day stuff.

The trick with working with XML in the database is to know when to store
it as XML and when to shred it into relational tables. If its a
structured document (looks like something you'd open in Word) save it as
XML. If it looks like something you'd open in Excel then start
shredding. And it looks like maybe you want to do a tv guide type thing.
   That is something you'll want to shred to tables.

> I'm looking for the functionality that I mentioned above that allowed
> more comprehensive XML operations but I'm just not finding any
> documentation for it, if it exists.

What exactly is it you are trying to do but cant?

Scott


pgsql-general by date:

Previous
From: Andreas Kalsch
Date:
Subject: Re: Unicode normalization
Next
From: Sam Mason
Date:
Subject: Re: Unicode normalization