Re: Format SQL (external tool)

Good idea, I'll switch this over to pgadmin-hackers. Thanks.

On Sat, Feb 1, 2014 at 10:06 AM, J.F. Oster <jinfroster(at)mail(dot)ru> wrote:

> 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.
>
>
>

--
Shane StClair
Software Engineer
Axiom Consulting & Design
http://www.axiomalaska.com