Page 1 of 1

SQL formatter or prettyfier?

Posted: Tue Jul 15, 2014 1:48 pm
by dbmsuser7
Anyone know of a program which will take SQL code and format it nicely, which works with SQL written for Vertica?

I imagine there are some generic formatters but I'm not sure whether they'd leave the code intact.

Re: SQL formatter or prettyfier?

Posted: Tue Jul 15, 2014 3:53 pm
by NorbertKrupa
I have yet to come across a good one. The one I generally use is Instant SQL Formatter with the MySQL or Generic database selected.

Re: SQL formatter or prettyfier?

Posted: Thu Jul 17, 2014 1:47 pm
by dbmsuser7
Thanks for your reply.

In what ways does "Instant SQL Formatter" fall short?

Re: SQL formatter or prettyfier?

Posted: Thu Jul 17, 2014 2:15 pm
by NorbertKrupa
It does not support some of the Vertica specific functions and will throw an error in the output.

Re: SQL formatter or prettyfier?

Posted: Tue Aug 14, 2018 9:56 am
by fomenkovoleg
Here is one more great service for beautifying SQL code - Online SQL Formatter http://sql-format.com/