Re: Format SQL (external tool)

Hello Shane,

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!


--
Best regards,
 J.F.