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). -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general