Re: XML -> PG ?

From: Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: XML -> PG ?
Date: 2009-05-06 15:53:56
Message-ID: 1241625236.8292.33.camel@debj5n.critical.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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).

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joao Ferreira 2009-05-06 16:04:00 Re: XML -> PG ?
Previous Message Gauthier, Dave 2009-05-06 15:40:40 Re: XML -> PG ?