Date: Wed, 25 Sep 2002 13:19:39 -0700 (PDT)
From: Philip Hallstrom <philip@adhesivemedia.com>
To: Andrew Perrin <clists@perrin.socsci.unc.edu>
Cc: pgsql-sql@postgresql.org
Subject: Re: SQL formatter?
In-Reply-To: <Pine.LNX.4.21.0209251342580.11079-100000@perrin.socsci.unc.edu>
Message-ID: <20020925131807.K47813-100000@cypress.adhesivemedia.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

Looks to be windows based, but...

http://www.techno-kitten.com/PBL_Peeper/Online_Manual/SQL_Formatter/sql_formatter.html

first hit when searching on google for "sql formatter".  there were a lot
of other options...

You might look at how some of those C code indenter's work.  Seems like
some of them support multiple languages which means they maybe have some
sort of "language definition" so maybe you could just write a sql one and
it would just work.  Of course I've never used one and don't know anything
about it really so I could be wrong :)

-philip

On Wed, 25 Sep 2002, Andrew Perrin wrote:

> Does anyone know of a routine for formatting SQL statements in a
> structured way? Standalone or for emacs would be fine.  I'm thinking of
> something that could take a long SQL text statement and format it, e.g.:
>
> select foo from bar where baz and bop and not boo;
>
> becomes
>
> SELECT     foo
> FROM       bar
> WHERE      baz
>    AND     bop
>    AND NOT boo
> ;
>
> Thanks,
> Andy
>
> ----------------------------------------------------------------------
> Andrew J Perrin - http://www.unc.edu/~aperrin
> Assistant Professor of Sociology, U of North Carolina, Chapel Hill
> clists@perrin.socsci.unc.edu * andrew_perrin (at) unc.edu
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>