[GENERAL] XML - PG ?

2009-05-06 Thread Gauthier, Dave
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. Thanks for any pointers !

Re: [GENERAL] XML - PG ?

2009-05-06 Thread Merlin Moncure
On Wed, May 6, 2009 at 10:47 AM, Gauthier, Dave dave.gauth...@intel.com 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. since xml is basically

Re: [GENERAL] XML - PG ?

2009-05-06 Thread Christophe
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

Re: [GENERAL] XML - PG ?

2009-05-06 Thread Gauthier, Dave
: Wednesday, May 06, 2009 11:23 AM To: Gauthier, Dave Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] XML - PG ? On Wed, May 6, 2009 at 10:47 AM, Gauthier, Dave dave.gauth...@intel.com wrote: Is there a way to read an XML file into a postgres DB?  I'm thinking that it will create and relate

Re: [GENERAL] XML - PG ?

2009-05-06 Thread Joao Ferreira gmail
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

Re: [GENERAL] XML - PG ?

2009-05-06 Thread Joao Ferreira gmail
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

Re: [GENERAL] XML - PG ?

2009-05-06 Thread Thomas Kellerer
Gauthier, Dave, 06.05.2009 17:40: Maybe... ALL EMPLOYEES EMP EMP_NAME=JOE JOB=CARPENTER / EMP EMP_NAME=FRANK JOB=PLUMBER/ EMP EMP_NAME=SUE JOB=CARPENTER/ /EMPLOYEES JOBS JOB JOB_NAME=CARPENTER SALARY=25.50 / JOB JOB_NAME=PLUMBER SALARY=28.75 / /JOBS /ALL

Re: [GENERAL] XML - PG ?

2009-05-06 Thread Joao Ferreira
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

Re: [GENERAL] XML - PG ?

2009-05-06 Thread Eric Schwarzenbach
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. Thanks for any pointers ! That's a pretty common problem, and not one that

Re: [GENERAL] XML - PG ?

2009-05-06 Thread John R Pierce
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. Thanks for any pointers ! As others have said, the fundamental problem is that

Re: [GENERAL] XML - PG ?

2009-05-06 Thread Ries van Twisk
On May 6, 2009, at 4:16 PM, Eric Schwarzenbach wrote: 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. Thanks for any pointers !