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]