Re: [GENERAL] Convert an XML database

2014-05-21 Thread Adrian Klaver
On 05/21/2014 08:03 AM, Aram Fingal wrote: a generic ETL (extract, transform, load) tool that supports XML and postgresql should be able to do it, but its not something built into postgresql as-is. I can't recommend any specific ETL tool to do this as I've never needed to do this exactly.

Re: [GENERAL] Convert an XML database

2014-05-21 Thread Aram Fingal
> > a generic ETL (extract, transform, load) tool that supports XML and > postgresql should be able to do it, but its not something built into > postgresql as-is.I can't recommend any specific ETL tool to do this as > I've never needed to do this exactly. Thanks. That at least tells me th

Re: [GENERAL] Convert an XML database

2014-05-20 Thread John R Pierce
On 5/20/2014 9:16 PM, Aram Fingal wrote: I want to set up a new PostgreSQL database from an XML database file. It seems like there should be an obvious way to do this but I can't seem to find any directions anywhere. How is this sort of thing normally done? you'd need some sort of tool that c

[GENERAL] Convert an XML database

2014-05-20 Thread Aram Fingal
I want to set up a new PostgreSQL database from an XML database file. It seems like there should be an obvious way to do this but I can't seem to find any directions anywhere. How is this sort of thing normally done? The database is available to the public here: http://www.drugbank.ca/downloa