Re: SQL parsing suggestions?

On 7/11/06, Vance Maverick <vmaverick(at)pgp(dot)com> 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