Skip site navigation (1) Skip section navigation (2)

Re: SQL scipts parser

From: "DGPickett" <DGPickett(at)aol(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: SQL scipts parser
Date: 2009-02-28 20:11:20
Message-ID: goc5pa$24vd$1@news.hub.org (view raw or flat)
Thread:
Lists: 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(at)fastcrypt(dot)com> wrote in message news:491f66a50902270722m16bcd0e4ha236878c7691b1f5(at)mail(dot)gmail(dot)com(dot)(dot)(dot)
  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(at)gmail(dot)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(at)postgresql(dot)org)
    To make changes to your subscription:
    http://www.postgresql.org/mailpref/pgsql-jdbc


In response to

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2009-03-02 09:10:30
Subject: Re: ResultSetMetaData.getColumnDisplaySize returns 2147483647 ?
Previous:From: DGPickettDate: 2009-02-27 17:41:11
Subject: Re: ResultSetMetaData.getColumnDisplaySize returns 2147483647 ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group