| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: XML -> PG ? |
| Date: | 2009-05-06 21:45:25 |
| Message-ID: | 4A0204F5.7040007@hogranch.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Gauthier, Dave wrote:
>
> Is there a way to read an XML file into a postgres DB? I’m thinking
> that it will create and relate whatever tables are necessary to
> reflect whatever’s implied by the XML file structure.
>
> Thanks for any pointers !
>
As others have said, the fundamental problem is that generalized XML is
freeform and inherently unstructured. Every piece of data can have a
different structure. IMHO, XML is fundamentally flawed by mixing the
metadata with the data.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Miguel Miranda | 2009-05-06 21:48:31 | Re: date ranges in where |
| Previous Message | Erik Jones | 2009-05-06 21:32:36 | Re: date ranges in where |