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