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

From Joao Ferreira gmail
Subject Re: XML -> PG ?
Date
Msg-id 1241625236.8292.33.camel@debj5n.critical.pt
Whole thread Raw
In response to Re: XML -> PG ?  (Christophe <xof@thebuild.com>)
Responses Re: XML -> PG ?  (Joao Ferreira gmail <joao.miguel.c.ferreira@gmail.com>)
Re: XML -> PG ?  (Joao Ferreira <jmcferreira@critical-links.com>)
List pgsql-general
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).


pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: Re: XML -> PG ?
Next
From: Joao Ferreira gmail
Date:
Subject: Re: XML -> PG ?