Re: XML -> PG ? - Mailing list pgsql-general

From Christophe
Subject Re: XML -> PG ?
Date
Msg-id 378C7BD8-CD13-4DE8-A104-57A08B4B0EAE@thebuild.com
Whole thread Raw
In response to XML -> PG ?  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Responses Re: XML -> PG ?
List pgsql-general

On May 6, 2009, at 10:47 AM, 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.

There's no built-in functionality that does what you describe, although building such a thing would be very straight-forward. There are many application-specific decisions you'd need to make (what level of hierarchy in the XML file corresponds to a database/schema/table, for example, and how to handle nested "fields" and missing ones).

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Transaction settings: nowait
Next
From: "Gauthier, Dave"
Date:
Subject: Re: XML -> PG ?