is there a tool to dump a database schema (SQL DDL) to XML?

Question

I'm looking to automatically generate an XML version of a database schema from SQL (Postgres) DDL.

Are there any tools to help with getting from the DDL to XML?

xml2ddl claims to do this, but it fails to connect and seems unsupported since 2005.

Answer 1

You can use the built-in table_to_xmlschema etc.; see http://www.postgresql.org/docs/current/static/functions-xml.html#FUNCTIONS-XML-MAPPING.