Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 85337476477 for ; Sat, 28 Sep 2002 23:03:09 -0400 (EDT) Received: from xyzzy.dhs.org (static-1M-b1-8.highspeed.eol.ca [64.56.237.8]) by postgresql.org (Postfix) with ESMTP id 6ED38476075 for ; Sat, 28 Sep 2002 23:03:08 -0400 (EDT) Received: from xyzzy.dhs.org (quux.lan.internal [::ffff:192.168.1.6]) by xyzzy.dhs.org with esmtp; Sat, 28 Sep 2002 23:03:12 -0400 Message-ID: <3D966EC1.3080508@xyzzy.dhs.org> Date: Sat, 28 Sep 2002 23:08:49 -0400 From: "Andrew G. Hammond" User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; en-US; rv:1.1a) Gecko/20020611 X-Accept-Language: en-ca, en-us, en MIME-Version: 1.0 To: Andrew Perrin Cc: Philip Hallstrom , pgsql-sql@postgresql.org Subject: Re: SQL formatter? References: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/401 X-Sequence-Number: 9678 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 > >