From: | Philip Hallstrom <philip(at)adhesivemedia(dot)com> |
---|---|
To: | Andrew Perrin <clists(at)perrin(dot)socsci(dot)unc(dot)edu> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: SQL formatter? |
Date: | 2002-09-25 20:19:39 |
Message-ID: | 20020925131807.K47813-100000@cypress.adhesivemedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)perrin(dot)socsci(dot)unc(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paesold | 2002-09-25 20:21:24 | Re: Getting current transaction id |
Previous Message | Gustavo Tadao Okida | 2002-09-25 19:38:59 | PL/pgsql |