On 7/11/06, Vance Maverick <vmaverick@xxxxxxx> wrote:
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?
I would load the schema definition into a postgresql server and then query information_shcema to introduce formatting :) In a previous project, I was able go generate COBOL fd files quite easily from postgresql tables/'views via simple querying off of information schema. merlin