Re: XML -> PG ?

hello,

as a perl addict I am... I recommend checking this out:

http://search.cpan.org/~cmungall/DBIx-DBStag/DBIx/DBStag/Cookbook.pm

it's pretty flexible and allows you to specify to some extent just how
the database structure is infered from the XML...

check it out

Joao




On Wed, 2009-05-06 at 11:31 -0400, Christophe wrote:
>
> 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).