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 >[EMAIL PROTECTED] * 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 >>>[EMAIL PROTECTED] * 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 [EMAIL PROTECTED] > > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
