I have a PostgreSQL schema definition. I'd like to be able to use it as the basis for code generation in a software build process -- specifically, I want to generate Java enums corresponding to the table definitions. However, it would be inconvenient to have to connect to a running database during the build. What approach would people suggest? I'm open to working in any language. Are there PostgreSQL parsing tools out there -- perhaps, the parser module itself from the database server? Or something from the JDBC driver, or the perl or PHP interfaces? Or does anyone have experience with other SQL parsers that can handle all the syntax of PostgreSQL files? Vance