| From: | Scott Bailey <artacus(at)comcast(dot)net> |
|---|---|
| To: | Nathan Widmyer <lighthousej(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Current state of XML capabilities in PostgreSQL? |
| Date: | 2009-09-16 22:14:13 |
| Message-ID: | 4AB16335.2000807@comcast.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sulman Sarwar | 2009-09-16 22:32:02 | Segmentation Fault during database restoration |
| Previous Message | Scott Marlowe | 2009-09-16 20:09:39 | wrong error from ./configure in pgsql 8.3.8 for libxml |