I'd like to see some code beautifier in PgAdmin too. Do you already have an eye to a CLI tool for this job?
I saw Free SQL Formatter (http://fsqlf.sourceforge.net/) under LGPL, which seems ok. May be, we can adopt it as a built-in default formatter (hope it will compile under MacOS, Solaris and FreeBSD). If things go well, it can be developed to support Postgre's SQL extensions and PL/pgSQL constructs as well.
In short, seems a good idea to me, I could participate in it's implementation :)
P.S. Should this be posted to [pgadmin-hackers]?
Saturday, February 1, 2014, 2:17:20 AM, you wrote: SS> Hi list,
SS> Just suggesting an idea. It would be really nice to be able SS> to configure an external command to format SQL in pgAdmin. After SS> configuring the external tool path in prefs, user hits a key combo SS> (Shift-Ctrl F?) and the highlighted query text (or all text if SS> none highlighted) gets run through the formatter and replaces the SS> original text in the query window. Would be flexible for the user SS> and seems fairly simple to implement in pgAdmin. Just a thought!
