Format SQL (external tool)

[Shane StClair]

Hi list,

Just suggesting an idea. It would be really nice to be able to configure an
external command to format SQL in pgAdmin. After configuring the external
tool path in prefs, user hits a key combo (Shift-Ctrl F?) and the
highlighted query text (or all text if none highlighted) gets run through
the formatter and replaces the original text in the query window. Would be
flexible for the user and seems fairly simple to implement in pgAdmin. Just
a thought!

Thanks,
Shane

[J.F. Oster]

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]

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

Post by J.F. Oster
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]?
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.

[Michal Kozusznik]

We are using SQL Assistant for a lot of tasks like code formatting,
Autocomplete, code searching etc. Really powerful tool.
Unfortunately pgAdmin developers has been rejected my request to make
CTRL-space hotkey optional in pgAdmin. Allegedly because of amount of
work needed to do it (lol).
I wouldn't count on any cooperation from pgadmin dev team. sad.

Post by Shane StClair
Hi list,
Just suggesting an idea. It would be really nice to be able to
configure an external command to format SQL in pgAdmin. After
configuring the external tool path in prefs, user hits a key combo
(Shift-Ctrl F?) and the highlighted query text (or all text if none
highlighted) gets run through the formatter and replaces the original
text in the query window. Would be flexible for the user and seems
fairly simple to implement in pgAdmin. Just a thought!
Thanks,
Shane
--
Shane StClair
Software Engineer
Axiom Consulting & Design
http://www.axiomalaska.com

[Craig Ringer]

Post by Michal Kozusznik
We are using SQL Assistant for a lot of tasks like code formatting,
Autocomplete, code searching etc. Really powerful tool.
Unfortunately pgAdmin developers has been rejected my request to make
CTRL-space hotkey optional in pgAdmin. Allegedly because of amount of
work needed to do it (lol).
I wouldn't count on any cooperation from pgadmin dev team. sad.

I'd like to remind you that PgAdmin-III is open source.

You are free to develop and contribute features that you feel are
desirable.

Sometimes this may involve revisions to the way they're implemented, and
sometimes the project may choose not to accept a patch, but usually
it'll be received with a grateful "thanks, that's handy".

[Guillaume Lelarge]

Post by Craig Ringer

Post by Michal Kozusznik
We are using SQL Assistant for a lot of tasks like code formatting,
Autocomplete, code searching etc. Really powerful tool.
Unfortunately pgAdmin developers has been rejected my request to make
CTRL-space hotkey optional in pgAdmin. Allegedly because of amount of
work needed to do it (lol).
I wouldn't count on any cooperation from pgadmin dev team. sad.

I'd like to remind you that PgAdmin-III is open source.
You are free to develop and contribute features that you feel are
desirable.
Sometimes this may involve revisions to the way they're implemented, and
sometimes the project may choose not to accept a patch, but usually
it'll be received with a grateful "thanks, that's handy".

Cannot agree more. Thanks, Craig.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com