Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL scipts parser - Mailing list pgsql-jdbc

From DGPickett
Subject Re: SQL scipts parser
Date
Msg-id goc5pa$24vd$1@news.hub.org
Whole thread Raw
In response to Re: SQL scipts parser  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Tree view
Maybe if you find an SQL style normalizer/beautifier, the comments will be very easy to find.  I should look for myself, as I have a favorite style of line breaks and indentation that I manually employ, over and over (one predicate per line, one column per line, one table name per line, etc.). 
The driver doesn't have anything like that in it. However check out antlr for SQL parsing.

Dave

On Fri, Feb 27, 2009 at 10:06 AM, Maciej Gawinecki <mgawinecki@gmail.com> wrote:
I'm looking for Java open-source SQL script reader/parser.

That would allow me to find SQL comments about tables and columns, usually given in the neighbourhood of CREATE TABLE, ALTER TABLE commands.

I suppose there's something like this in JDBC for PostgreSQL. Can you point me the sources/classes containing such a parser?

Best,
Maciej

--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

pgsql-jdbc by date:

Previous
From: DGPickett
Date:
Subject: Re: ResultSetMetaData.getColumnDisplaySize returns 2147483647 ?
Next
From: Oliver Jowett
Date:
Subject: Re: ResultSetMetaData.getColumnDisplaySize returns 2147483647 ?