Re: XML -> PG ?

On Wed, 2009-05-06 at 16:53 +0100, Joao Ferreira gmail wrote:
> 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...


... maybe start here to get a faster grasp:

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

j


>
> 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).
>
>