I have an XML files to read and load into database daily at night (cron) So i planed to do this in a batch. Is there any command line tool to :
1. Create a postgres schema using an XSD file?
2. Transform an XML file into SQL commands for postgres?

Any other solution is welcome.


You can generate SQL commands to import your file using xmlstarlet.

Here is an example.

  • 1
    I see. The example is for MYSQL but i can do the same for postgres. What about the schema creation? – Nadina May 28 '14 at 19:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.