Обсуждение: SQL scipts parser
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
The driver doesn't have anything like that in it. However check out antlr for SQL parsing.
Dave
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
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.).
"Dave Cramer" <pg@fastcrypt.com> wrote in message news:491f66a50902270722m16bcd0e4ha236878c7691b1f5@mail.gmail.com...The driver doesn't have anything like that in it. However check out antlr for SQL parsing.
DaveOn 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