Postgres Pro
Downloads
Home   >   mailing lists

Thread: SQL scipts parser

SQL scipts parser

From
Maciej Gawinecki
Date:
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

Re: SQL scipts parser

From
Dave Cramer
Date:
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

Re: SQL scipts parser

From
"DGPickett"
Date:
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