SQL parsing suggestions?

From: Vance Maverick <vmaverick(at)pgp(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: SQL parsing suggestions?
Date: 2006-07-11 15:49:28
Message-ID: 1152632969.31153.3.camel@vmaverick-linux2.pgp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2006-07-11 15:57:19 Re: Notes on converting from MySQL 5.0.x to PostgreSQL
Previous Message Jan Wieck 2006-07-11 15:45:31 Re: Notes on converting from MySQL 5.0.x to PostgreSQL