I have been given an xml file and it's pretty obvious in looking at the contents that it contains an inherent schema. What I'd like to do is run a program against it that outputs the schema represented by the contents, then create said schema in / as a database (in Postgres), and then populate said database so I can run SQL queries against the data.
I figured that this has to be a commonly desired capability, but I've never needed to do this before and am not sure what already exists.
I work in Postgres, and it has many XML related tools, so I figure that's a good place to look but so far haven't found it.
Doing some digging, I found that the people who gave us the xml file also have an "xml schema file" that matches, and I've gotten a copy. It's on the web here for those that care.)
OK, so step one was satisfied; get to an "xml schema."
Now I need to convert that into an SQL schema...