Re: SQL formatter? - Mailing list pgsql-sql
From | Andrew G. Hammond |
---|---|
Subject | Re: SQL formatter? |
Date | |
Msg-id | 3D966EC1.3080508@xyzzy.dhs.org Whole thread Raw |
In response to | Re: SQL formatter? (Andrew Perrin <clists@perrin.socsci.unc.edu>) |
List | pgsql-sql |
There's a tool called TXL that, given an SQL grammar can pretty print it. (a semantically aware code transformation tool is massive overkill for the job, but what the hell... :) Andrew Perrin wrote: >Unfortunately it is Windows based. The emacs mode for SQL is pretty >primitive too. Oh well - maybe I'll write one someday. > >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 > > >On Wed, 25 Sep 2002, Philip Hallstrom wrote: > > > >>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 >>> >>> >>> >>---------------------------(end of broadcast)--------------------------- >>TIP 5: Have you checked our extensive FAQ? >> >>http://www.postgresql.org/users-lounge/docs/faq.html >> >> >> > > >---------------------------(end of broadcast)--------------------------- >TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > >