Re: [GENERAL] Convert an XML database
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. Thanks. That at least tells me that I am not missing something which would make this really easy. The other thing to keep in mind is this note at the link you provided: "The XML schema is currently in beta and is likely to change in the coming weeks." -Aram -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Convert an XML database
> > 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 that I am not missing something which would make this really easy. -Aram -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Convert an XML database
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 could parse the XSD schema definition and generate SQL create table commands, then read the XML data and insert it into the database. 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. there's some ETL tools listed here, http://en.wikipedia.org/wiki/Extract,_transform,_load -- john r pierce 37N 122W somewhere on the middle of the left coast -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Convert an XML database
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/downloads#full -- Aram -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general