Thread: SQL formatter?
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
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 >
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 >
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 > >